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

G

Guest

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
 
G

Guest

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

Worksheet size 65,536 rows by 256 columns

Thanks for the gentle response.
 
G

Guest

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

Export Access table to Excel that has more than 65000 records 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Urgent ! How to export more than 65535 rows to Excel ? 3
How to export table from outlook into ms access table? 0
Export more than 65536 records from ADP to excel 2007 12
export to exel 1
file type export problem 5
Error Saving Import/Export Spec 1

Top