Import with a wild card

[ukgooner]

Hi - can anybody tell me how I can import a file into an Access db using a wild card. I need to import on a daily basis, but the source file changes it's name every day, i.e. it adds a date suffix to the name. I have tried using * and % without success.

[dcrake]

As explained on another post earlier, If you translate today's date into the name of the file you do not need to use wild cards.

Lets say the file is called "C:\Test\Fred090909.xls"

We now by using the Date() function we can derive the date

Today = Format(Date(),"ddmmyy")

So the file we need to import is

sFile = "C:\Test\Fred" & Today & ".xls"

We can then use sFile as a variable

DoCmd.TransferSpreadsheet acImport, 8, "TblTest", sFile ,True, ""

David

[ukgooner]

Thanks David, but not quite as simple as that. An external server processes a (text) file that I need to import and appends a service number as well as the date, e.g. myfile_090909svc345.txt

[dcrake]

The only way then is to see what the logic is for the naming conventions for the service numbers and create a log file that holds the service numbers of the files imported. Then get the next sequential number and concat that into the file name. The only issue here is if the names are not sequential to you. Alternatively you may need to populate a list box with files of that date mask in to a list/combo box and let the user select.

David