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.