I am attempting to automate the import of a text file (fixed with fields). I have created a fixed width import specification using the "Advanced" button on the import wizard form and saved it.

Now I would like to automate the import of this text file, while also being able to specify/use the previously saved field width specification.

Does anyone know how might do this? I am familiar with VBA TransferDatabase method, but can't seem to find where one can specify the name of the saved import SPEC.

Any help would be appreciated.

EDIT: Never mind (when all else fails turn to the documentation!) --> DoCmd.TransferText