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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
How many records will your version of Excel accept?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Ahh, I see the problem. It's in Excel.

Worksheet size 65,536 rows by 256 columns

Thanks for the gentle response.
 
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.
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to export table from outlook into ms access table? 0
Export Access table to Excel that has more than 65000 records 5
Urgent ! How to export more than 65535 rows to Excel ? 3
Export more than 65536 records from ADP to excel 2007 12
Exporting table containing dates 6
excel pivot export to access 2
Exporting limitations in Access 1

Back
Top