I have created a text file specification using the import wizard in Access 2007. I want to automate this process and have the user run a macro which will make a call to a vb fuction. In my code see below I use the name of the import specification as one of the function arguements. When the macro runs I receive an error stating the text file specification does not exist. When I go into access I can see the specification I saved.
DoCmd.TransferText acImportDelim, "TXMAST1", "TXMAST", "TXMAST.txt"