Check out:

http://support.microsoft.com/default...b;en-us;120596

I know I have a book co-authored by Mr. Excel (www.mrexcel.com) that also
addresses this problem, but I don't have it handy.

If you have that much data, it might be easier to import it into Access and
then pull the data (65536 row at a time) into separate worksheets. (That may
be how Mr. Excel talks about doing it.)


"JH" wrote:

Hi, I have a text file with many pages. It will exceed the maximum number of
rows in one Excel worksheet. Is it possible to use the OpenText method to
import this file to more than one worksheet? If not, what is the best way to
import this file?
Thanks!