Excel 2003 Importing large delimited text file

[Ron]

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

 

[Frank Kabel]

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

 

[Ron]

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

Hi Frank, thanks for that advice.

It turned out the text file had over 1 million rows of similar data.

I imported into Access [which handled it all no problems] and did a few
filters and exported it that way.


Regards,

Ron