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

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

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

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/prev...n/default.mspx
Excel 2007 has 1048576 rows (2 ^ 20) compared to now 65536 (2 ^ 16) rows.

RBS

wrote in message
oups.com...
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

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

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