| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do a import data from a text file to an excel worksheet | Excel Discussion (Misc queries) | |||
| import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
| import multiline data from text file | Excel Discussion (Misc queries) | |||
| import data from a text file | Excel Discussion (Misc queries) | |||
Hybrid Mode
