Large files
 

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?

Large files
 

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.
--
John C


"Ray S." wrote:

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?

Large files
 

1,048,576, to be exact
Bob Umlas
Excel MVP

"Ray S." wrote in message
...
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?