I have a strange issue that I cannot work out.
I have an excel import into a table.
The table comprises of 5 columns. ID (Which is being imported blank so the table can auto number it. Also the Primary Key), Usercode, CourseID, Progress and Mail.
All are number fields and set as number fields.
If I try and import through a macro on my front end, I get a Run time 3349 error. However, when manually importing the spreadsheet into the back end, the data goes in fine with no error.
I've attached the code below for the import, but I can't figure out why the manual import is fine but the vba code on the front end is erroring.
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_progress", file1, True