Importing large text files to excel

Giganews Newsgroups
Subject: Importing large text files to excel
Posted by:  MCI (3300…@gmail.com)
Date: Tue, 22 Jul 2008

Hi, i am using Excel 2002, and I am wondering what is an efficient way
to import text files with more than 65536 lines to excel (eg. if it's
120000 lines, I want the excel workbook to automatically create two
tabs, with the first tab having the first part of the text file, line
1 to line 65000, the second tab having line 65001 to 120000.)

Right now, i am using a splitter (HJSplit) to first manually split the
large text file into several small files, then i import each file to
an individual tab in a excel workbook. But obviously that's not the
best way.

Thank you very much.

Replies