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
 
Back
Top