Exporting 600K records to Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a trick to exporting 600K records into Excel 2007? I have only been
successful in exporting the traditional 65K records?

TFTH,
Tom
 
Tom

Hmmm? How do you stuff 20 lbs. of flour into a ten pound sack? <g>

Since Excel limits the rows to 65K in a worksheet, how do you proposed to
put 600K rows there?

Have you looked into putting the first 60K into Sheet1, the second 60K into
Sheet2, ...?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Hmmm Jeff. Excel 2007 has a 1 million row limit so we need to look elsewhere
for the issue. Perhaps the OP is using an Access version prior to 2007, one
that doesn't know about the new and improved 1M row limit

Since he didn't give much to go on, I'd suggest he export to a CSV or tab
delimited format, then import that file into Excel.
 
And 16,384 columns! Just wait until somebody tries to import one of those
monsters as Access 2007 is still limited to 255 fields.
 
Back
Top