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

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/comm...lic.excel.misc

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

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?

madlin wrote:

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/comm...lic.excel.misc

--

Dave Peterson

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

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.
--
Yanick


"madlin" wrote:

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/comm...lic.excel.misc

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

Can you split the text file into 2 files, and then import each of those as a
seperate sheet into XL?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"madlin" wrote:

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/comm...lic.excel.misc

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

I would first import them to a ACCESS table and then export from ACCESS to
Execel.

"madlin" wrote:

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/comm...lic.excel.misc