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.
 

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 best way to export 600K records 2
Cougar 600K Mechanical Keyboard 0
Export 65k+ file 9
Export Access table to Excel that has more than 65000 records 5
Export to XML - error 31532 0
Exporting to Excel 2007 1
Exporting access table to excel through Office link option 2
Exporting more than 65K records to Excel 4

Back
Top