access is giving error 3709 on one button

**odiez1** · 09-15-2022, 12:36 AM

access is giving error 3709 on one button

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 problem

Did ask in this forum, but thre are not many users on it. http://www.vbaexpress.com/forum/show...794#post416794

Code:

Private 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

**orange** · 09-15-2022, 05:45 AM

odiez1,
You post has been approved for others to see. Your post at vbaExpress does have some responses.
I think we need more info about the database involved and the import specification. Since a key player is leaving your organization, I suggest you get as much info from that person as possible as soon as possible.
Good luck and Welcome to the forum.