Chip Pearson has a macro you can try from he

http://www.cpearson.com/excel/ImportBigFiles.aspx

Hope this helps.

Pete

On Oct 6, 11:29*am, EricB wrote:
Importing multiple lines into Excel from txt. or MSWord

I have data comprising of some 325.000 rows, naturally .csv on allows a
little over 65.000.
How can I imports or paste data from txt. or Word into EXCEL that the
program creates more than one page to accept all the data.

The macro onhttp://redirx.com/?33qfgave me an “out of memory’ result.

Regards

EricB