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