Maybe you could use the code found here..........

http://support.microsoft.com/default...;en-us;Q120596


Gord Dibben MS Excel MVP

On 30 Jun 2006 21:11:28 -0700, wrote:

I would like to import tab determined text data into excel, but I have
to handle more than 65K rows. Colum is determined 47.

How can I make VBA?

Please give me some advices.

Regards,
Shinchan