I have been using 'Late Binding' to import data froman Excel File to an Access 2016 Table.
Im now trying to create a new import function.
A while ago John Tsioumpris and Mark Edwards suggested the TransferSpreadsheet method.
I have coded it as follows but it doesn't import anything.
DoCmd.TransferSpreadsheet acImport, 10, RS07ImportDataAddGrp0003, "M:\Web\Att\firstname.lastname@example.org-Co-op Camp Registration 35th GA.xlsx", False, ""
The Excel Spreadsheet has 2 Columns (A & B) with 121 Rows although in production the number of rows won't be known
Can you tell me what is wrong with the systax of the command?