Large files

R

Ray S.

I'm trying to export 250,000 records from an MS Access table into Excel. I
have 2003, and I get a message saying I should break it up into about 65,000
record bits. I've heard that Excel 2007 can handle about 1,000,000 records.
Is that true?
 
J

John C

xl2003 worksheets have only 65,536 rows. I don't know how many rows are in an
xl2007 worksheet, but I know it is well over 1 million.
 

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

Merging from an Excel file with graphics 1
Exporting large tables 0
Adding data to MS Access from csv file 0
Sorting a csv 2
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
How to break up a book's endnotes by chapter in a file containing a whole book? 0
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Rounding difference in Access 2003 text exports 2

Top