Import Large Text into Excel Worksheet

[Guest]

I'm trying to open several large text file of 172800 lines for processing in Excel, however excel only allows 65536 lines in the worksheet. Text Import Wizard also present the same problem. Also, the max line I can start importing in Text Import Wizard is 32767 making it impossible for me to import the whole 172800 lines in the file.

My intention is to import the large text into several worksheet i.e. 172800 distributed nicely into 3 worksheets but I do not know how.

I've 1400 or 11GB or such .txt files to open into excel so manual spliting the .txt files are not an option.

Would appreciate if any Excel guru can help me with this.

 

[Dave Peterson]

You could use your favorite text editor and split it up into 3 smaller
parts--then import each 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

======
Any chance you don't need all 172800 lines. Maybe cleaning the file outside of
excel would be worth doing.