Hi,
I have an automated Excel-file import where the user can choose the excel-file with routes to drive.
DoCmd.TransferSpreadsheet acImport, 8, "tblRoutes", selectFileWithoutDoubleCheck(), True, "!A1:L1000"
The headers all aready there in tblRoutes.
Now every day column K1 of the Excel file...