View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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