Import tab text data(more than 65K rows) into excel by VBA

[hamano0112]

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

 

[RB Smissaert]

There are a number of options:

1. Don't use Excel, but instead Access.
2. Use File I/O and take chunks of the file and put
in different sheets.
3. Download the Office 2007 beta:
http://www.microsoft.com/office/preview/beta/download/en/default.mspx
Excel 2007 has 1048576 rows (2 ^ 20) compared to now 65536 (2 ^ 16) rows.

RBS

 

[Gord Dibben]

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

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596


Gord Dibben MS Excel MVP