Importing large text files to excel


M

MCI

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.
 
Ad

Advertisements

Ad

Advertisements

D

Dave Peterson

I'd continue to use HJSplit (maybe even mechanize it in a macro).

Then record a macro that would open both text files and parse them the way I
want.

Then when I needed to do it again, I'd run the macro (or HJSplit and then the
macro).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top