automatically importing text file

[tekvb1977]

I like to automatically import text file into an access table without going through the manual process. I also need to select advance spec when I do the import process automatically.

How could I do it using VBA. Thanks for your help in advance.

J

 

[PHV]

Have a look at the DoCmd.TransferText method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886