Hello,
I know how to import a file into a table using this code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TableName", FileAddress, True, "WorkSheet!"
Is there a way to transfer multiple worksheets from the same workbook with one DoCmd.TransferSpreadsheet?