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