This is a really weird one ... I am trying to import an excel spreadsheet into Access using the following code:
DoCmd.TransferSpreadsheet acImport, , "SMS Import", "C:\Users\xxxx\Desktop\SMS Import.xlsx"
I keep getting an error saying "Field F1 doesn't exist in destination table 'SMS Import'" - so to make sure I wasn't missing anything I exported the data that already existed in the table to excel and then tried to reimport it - I still got the same error!
Any ideas - I have tried adding a reference to Microsoft Excel 14.0 Object library as well as Microsoft Office 14.0 Object library - no difference though