I'm using the following code to upload a csv file into an access table:

DoCmd.TransferText acImportDelim, "TradesSpec1", "tbtrades", strFileName, True, ""

It works completely fine, except that strFileName is var which references a filename.

When the filename is hardcoded it works fine.
When the wildcard * is used to replace characters I get error message 3011.

The filename is made up of a date and time which are unpredictable so I want to use a wildcard because I'll never be able to guess the exact name of the file.

Can anybody help? Can wildcards be used when using the transfertext command?