Hi
one possible workaround (without VBA): Use a text editor of your choice to
split the file before importing

--
Regards
Frank Kabel
Frankfurt, Germany
"Ron" schrieb im Newsbeitrag
10.131...
Hi guys,

Not so much a vba question but a puzzling on nonetheless.

I have a huge text file, way over 65000 rows, probably fill a few dozen
sheets.

Obviously the text import wizard will only fill down to 65536. However
when
I actually import I get a message saying I can carry on the import in a
new
sheet telling the wizard to not import rows that I've already imported.

But I cannot find any facility to do this anywhere in the wizard.

Anyone come accross this and gotten over this hurdle?

Regards,

Ron