Thread: Importing multiple lines into Excel from txt.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Importing multiple lines into Excel from txt.
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

Reply With QuoteReply With Quote