"Frank Kabel" wrote in
:

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