Hi

Split your file to several files with <65536 rows in each. You can use any
text editor, capable open your file, for this. Create a copy of original
file, and delete all rows except # first ones (# being the number of rows
you want to left in file). Then create a next copy of original file, and
delete # rows at top, and then all rows except # first ones, and so on.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"ibu" wrote in message
...
is it possible to increase the number of rows of a worksheet beyond 65536?
if
yes, how? if no, any workarounds? I need to read in a text file in CSV
format
with more than 1,000,000 lines.

thanks!