RunSavedImportExport - How to Change Path, or How to TransferSpreadsheet?

[MattGreer]

I have an Excel (xlsb, Office 365) spreadsheet that I'm using to import data to Access. This command works quite well:

DoCmd.RunSavedImportExport "ImportForecastData"

Unfortunately, the location of the database and excel file will change, thus breaking the saved Import.

I tried to import the spreadsheet as follows, but I was unable to specify the specific table in the Excel file to use. How can I point to the named Excel table?

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, varTable, varName, True, "DailyData"

Thanks!!


Matt

 

[lameid]

There is a range parameter to transferspreadsheet... I would expect you could put your table or named range in there too...