How do I import data from a text file into Excel 2003

[madlin]

My data exceeds the number of lines in excel. Is there a way to import all
of the data into multiple worksheets?

 

[Sheeloo]

In Excel 2003? Not really...

You can either break your files into smaller pieces or write code to import
it into multiple sheets.

Excel 2007 allows 1,048,576 rows. See
http://office.microsoft.com/en-us/excel/HP100738491033.aspx

 

[Gord Dibben]

Run a macro to split as you import.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596


Gord Dibben MS Excel MVP