| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Really large files, not sure why | Excel Worksheet Functions | |||
| Handling Large Files | Excel Discussion (Misc queries) | |||
| Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) | |||
| Modifying large CSV files | Excel Discussion (Misc queries) | |||
| Exceptionally large files | New Users to Excel | |||
Hybrid Mode
