How do a import data from a text file to an excel worksheet

  • Thread starter Thread starter madlin
  • Start date Start date
M

madlin

I have more than 66,000 lines of data to import into excel (v.2003). Can I
do this without loosing data?
--
mad

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d-b07371684b38&dg=microsoft.public.excel.misc
 
xl2003 only has 65536 rows per worksheet.

You could use your favorite text editor and split the data into smaller pieces
and then import each of the smaller pieces into separate worksheets.

Probably not what you want, huh?
 
I think the best way is to load your data in Access, then slipt your data in
2 with queries to load them back in Excel after.

Hope it will help.
 
Can you split the text file into 2 files, and then import each of those as a
seperate sheet into XL?
 
Back
Top