Adding to Dave, you might consider an upgrade to Excel 2007 or 2010 where
you have 1million rows to work with.

Best wishes Harald

"jo77" wrote in message
...
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