Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - importing a large .csv file
I am importing a very large csv file and when I try to set up the correct
next line for worksheet 2, I get an error "integer not valid". Worksheet one stoped at line 65,536 but the impor editor will not let me enter any number larger than 9999 as the next starting line. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - importing a large .csv file
Maybe you can split the text file outside of excel -- using your favorite text
editor??? Linda in Wyo wrote: I am importing a very large csv file and when I try to set up the correct next line for worksheet 2, I get an error "integer not valid". Worksheet one stoped at line 65,536 but the impor editor will not let me enter any number larger than 9999 as the next starting line. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - importing a large .csv file
Chip Pearson has a macro you can download from he
http://www.cpearson.com/excel/ImportBigFiles.aspx which allows you to import files with more than 64k records - it automatically puts the next lot of records in a second sheet. Hope this helps. Pete On Nov 7, 10:49*pm, Linda in Wyo wrote: I am importing a very large csv file and when I try to set up the correct next line for worksheet 2, I get an error "integer not valid". * Worksheet one stoped at line 65,536 but the impor editor will not let me enter any number larger than 9999 as the next starting line. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - importing a large .csv file
Hi,
Actually, the import wizard will allow you to bring in more than 65536 row, but there is a limit. First import starting on row 1 this will bring in 65536 or so rows. Then on a different sheet set the starting number at 32767, the biggest number the wizard will allow. This will bring in rows 32676 down to about 65536+32676. -- Thanks, Shane Devenshire "Linda in Wyo" wrote: I am importing a very large csv file and when I try to set up the correct next line for worksheet 2, I get an error "integer not valid". Worksheet one stoped at line 65,536 but the impor editor will not let me enter any number larger than 9999 as the next starting line. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - importing a large .csv file
Hi,
I've done a little checking and as best I can determine Excel 2007 allows you to import up to 1,048,576 rows at a time and has an upper limit on the start row of 99,999,999! -- Thanks, Shane Devenshire "Linda in Wyo" wrote: I am importing a very large csv file and when I try to set up the correct next line for worksheet 2, I get an error "integer not valid". Worksheet one stoped at line 65,536 but the impor editor will not let me enter any number larger than 9999 as the next starting line. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Cell Comments causes large file size? | Excel Discussion (Misc queries) | |||
Large File Size in 2003 | Excel Discussion (Misc queries) | |||
Importing (too) large data file | Excel Discussion (Misc queries) | |||
Importing a large file | Excel Discussion (Misc queries) | |||
Importing a large text file | Excel Discussion (Misc queries) |