Need to import .txt file using the extension only.

[PJ Crittenden]

I'm using a macro, TransferText and I want it grab whatever text file is in that folder. I've tried \*.txt but get a message that the database engine could not find *.txt. If I type in the complete name, it works...but I don't want to always retype the file name.



I also want to move the file once it's imported into Access, and I created a module that copies the file to the new folder, but the file is still in the original folder as well. I need to delete it as part of the process. Can you help with that too?

Thanks.

[PJ Crittenden]

I got the "delete" part figured out. Still need help with importing a .txt file without typing the entire file name.

[ItsMe]

Perhaps the solution is to use VBA

[rpeare]

I agree with itsme, vba is the solution here.

Look at filesystemobject commands to handle file/folder manipulation