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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

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
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
how to import more than 1 text file into the same Excel worksheet.	=?Utf-8?B?U2lubmV0QlM=?=	Microsoft Excel Misc	1	14th Jun 2006 03:14 AM
Import Data from the different worksheet in the same excel file.	hem3414	Microsoft Excel Discussion	3	27th Dec 2005 05:52 PM