How to export Ms Access table with more than 65536 records?

M

Makeda42

Is it possible to export a Ms Access table with more than 65,636 records into
an Excel format? Is Text format the only option that will work?

I'm running Access 2002.
 
J

Jeff Boyce

How many records will your version of Excel accept?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Makeda42

Ahh, I see the problem. It's in Excel.

Worksheet size 65,536 rows by 256 columns

Thanks for the gentle response.
 
J

Jerry Whittle

Jeff is probably alluding to the fact that Excel 2007 can handle around a
million records if I remember correctly. I believe that you need Access 2007
also.
 
J

Jeff Boyce

You're giving me way too much credit, Jerry!

I was just checking to see if the OP was trying to stuff 10 lbs of flour in
a 5 lb sack...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Excel does not accept text format! 0
Export Access table to Excel that has more than 65000 records 8
Export Report with Graph to Excel error 2495 1
Insert multiple objects at once ? 3
Urgent ! How to export more than 65535 rows to Excel ? 3
Export Access pivot table to Excel 0
How to Import Formatted text as new Slides in PowerPoint 0

Top