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

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

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

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/ex...738491033.aspx


"madlin" wrote:

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

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

Run a macro to split as you import.

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


Gord Dibben MS Excel MVP