i need to import a huge txt file into excel

[Guest]

i need to import a hug txt file into excel but failed because insufficient
rows. is there anyway i could increase rows without using access?

 

[SteveW]

i need to import a hug txt file into excel but failed because
insufficient
rows. is there anyway i could increase rows without using access?

no, apart from upgrading to Excel 2007

search group for some previous answers on this I think there are was to
"read"
the file in several stages

Of course the right answer shoudl have been - use access

 

[Guest]

I've used this sucessfully in the past

http://www.danielklann.com/excel/importing_large_text_files_into.htm

or the Microsoft solution which I haven't tried.

http://support.microsoft.com/kb/120596

Mike

 

[Chip Pearson]

I have extensive notes and lots of example code at
http://www.cpearson.com/excel/ImportBigFiles.htm .

It will handle importing files of any size, splitting the data across as
many worksheets as necessary.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)