Thread: Import tab text data(more than 65K rows) into excel by VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
  
Posts: 2,452
Default 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


Reply With QuoteReply With Quote