Importing Excel

[Palhay]

I am trying to import a sheet from excel daily with the external data - saved imports tab in Access 2010 the problem is the sheet name changes daily to reflect the days date.

[JoeM]

You can program it in VBA so it uses today's date in determining which tab to import, i.e.

    Dim mySheetName As String

'   Import the tab named with today's date in mm-dd-yyyy format
    mySheetName = Format(Date, "mm-dd-yyyy")
    DoCmd.TransferSpreadsheet acImport, 10, "MyTable", "C:\C\MyImportFile.xlsx", True, mySheetName & "!"