access is giving error 3709 on one button

[odiez1]

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


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

Not sure what and how to fixed this problem

[arnelgp]

if you google Error 3709, you will find lots of hit and some solutions
that you can try.

if you are unable to solve it, you can attach your db and excel file (in .zip format)
for analysis. just mention which form and button has the fault.

[Aussiebear]

Was there meant to be an alternative option? You have the basic construct of an If.. then.... else, but no option on the else section.

[Gasman]

Crossposted (with responses) at https://www.accessforums.net/showthread.php?t=86655

[odiez1]

Here are the two files excel and database.
try to use "Make new insert table to get dat" button

[odiez1]

Here are the two files excel and database.
try to use "Make new insert table to get dat" button
Password = melandri

[odiez1]

if you google Error 3709, you will find lots of hit and some solutions
that you can try.

if you are unable to solve it, you can attach your db and excel file (in .zip format)
for analysis. just mention which form and button has the fault.
did add files

[Aussiebear]

What were the results of the responses you received from accesaforums.net?

[odiez1]

Did get the answer from the other form, and it is working.
Ribbon>External Data>Saved Imports

[Aussiebear]

Thank you for the update