Exporting 600K records to Excel 2007

T

tom

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

TFTH,
Tom
 
J

Jeff Boyce

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/
 
D

Duke Carey

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.
 
J

Jerry Whittle

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

VBA Export to PDF 0
the best way to export 600K records 3
VBA - exporting serial letters to single documents 0
Merge Excel file into Word Document 3
Export 65k+ file 9
Access-->XML-->Excel: Size Limitations? 0
Can't export to EXCEL file 1
How do I export a report to Excel in Access 2007 1

Top