Split a text file with more than 65536 lines over many worksheets

  • Thread starter Thread starter jo77
  • Start date Start date
J

jo77

Hi everyone,
I would like to process a text file with more than 65536 lines. Is
there any possiblity to do that with Excel ?
Either to do it in many iterations (like import lines 1 to 65536, then
65537 to 131072, and so on) or to import it once and split lines 1 to
65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc...

Thanks for any feedback & have a great weekend!

Joel
 
I would use a text editor to split the text file into smaller pieces (maybe
notepad???).

Then you can import each piece into different worksheets/workbooks.
 
Hi

Upgarde your MS-Office to Office 2007 is the best possible solution.

Regards
Rajender Soni
 
Hi everyone,
I would like to process a text file with more than 65536 lines. Is
there any possiblity to do that with Excel ?
Either to do it in many iterations (like import lines 1 to 65536, then
65537 to 131072, and so on) or to import it once and split lines 1 to
65536 on sheet 1, lines 65537 to 131072 on sheet 2 etc...

Thanks for any feedback& have a great weekend!

Joel
Click to expand...

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