Need to import an Excel Spreadsheet on a daily basis

[postlethwaited]

Hi, I am gong to import an excel spreadsheet on a daily basis as per the instructions in thread181-946762. My problem is that the name of the spreadsheet changes on a daily basis - to include todays date - so the file is called c:xxxxddmmyy.csv.

Is there any way to adapt the code to account for this?

thanks

 

[Remou]

Use the macro to run code. You can then use a different name each time:
[tt]strFile = "C:\xxxx" & Format(Date,"ddmmyy") & ".csv"
DoCmd.Transferspreadsheet acImport, <...>, "tblTable", strFile[/tt]