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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

Run a macro to split as you import.

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

Gord Dibben MS Excel MVP

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Text file Data into Excel Sheet	vicky	Microsoft Excel Programming	3	1st Dec 2009 01:02 PM
Import Access data to text file rather than Excel	Daniel Bonallack	Microsoft Excel Programming	3	5th May 2009 11:51 PM
Excel 2003 - VBA - Text File Import	C Brandt	Microsoft Excel Misc	2	4th Dec 2007 05:19 PM
data is corrupted when I import text file into Excel	=?Utf-8?B?VG9tbXk=?=	Microsoft Excel Crashes	1	27th Jun 2007 08:26 PM
Import data from Excel file or text file into database in ASP.NET program	bienwell	Microsoft ASP .NET	2	17th Jun 2006 04:57 AM