Importing all fields in a text file as text without an import spec

[JoGreen]

Hi...

Is there any way in VBA to import all fields in a text file as text without using an import spec?

My problem is that the field order and field name can vary slightly from import to import, but I need the fields to come in as text initially to avoid type mismatch errors.

Thanks for any suggestions.

 

[beetee]

I posted some sample, tested VBA code into an FAQ, it should be available in a day or two.