var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Using a wildcard when transfering text
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?