I an noop on access and excel.
I have received a access file from a person that is leaving the company.
I did received the access file and the excel file.
But when I try to insert the data from the excel file, it gives me the error "3709"
and when i run debug it shows the error on this code
Not sure what and how to fixed this problemPrivate Sub btnimport_Click() If MsgBox("Are you sure you want to import Date to Insert Table?", vbYesNo + vbQuestion) = vbYes Then DoCmd.RunSavedImportExport ("Import-insert") Else End If End Sub