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?

On Sun, 28 Jan 2007 07:36:00 -0000, Adelne
wrote:

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

--
Steve (3)

I've used this sucessfully in the past

http://www.danielklann.com/excel/imp...files_into.htm

or the Microsoft solution which I haven't tried.

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

Mike

"Adelne" wrote:

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?

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)

"Adelne" wrote in message
...
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?