I am using vba to import two excel spreadsheets into Access like this
Now, sometimes there will be an error on the import and a error spreadsheet will be created called XXXX_ImportErrors - I want a way to link that error table back to the imported table so I can show relevant data to the user to let them know what the issue was and hopefully remedy it.Code:DoCmd.TransferSpreadsheet acImport, , "vbaPLU", Me.txtPLU.Value, True DoCmd.TransferSpreadsheet acImport, , "vbaPTI", Me.txtPTI.Value, True
Question being, since I am importing two spreadsheets into two different tables - how do I link the ImportError table to the table that was created by the vba import?