Importing a text file w/ more than 65,536 rows

[Nick]

I'm trying to download a text file which exceeds the
number of rows on an Excel worksheet. The help menus for
Excel 5.0, 7.0, and '97 specify a way to use the Text
Import Wizard to import the file to multiple worksheets.
However, I have Excel 2000, and cannot locate any
instructions about how to download to multiple worksheets.
Anyone have any suggestions?

 

[Dave Peterson]

I'd use my favorite text editor and split the text file into smaller pieces.

Then import them separately.

Or you could use a macro that imports each line:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm