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?