Split a text file with more than 65536 lines over many worksheets
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.
On 07/16/2010 07:23, jo77 wrote:
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
--
Dave Peterson
|