Share via

Run-Time error '3709':

Anonymous
2014-03-11T16:55:00+00:00

When I try to run the following code I get the run-time error '3709':

Sub ImportfromExcel()

Dim MyPath As String

MyPath = "C:\Temp\GDXData.xlsx"

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "GDXData", MyPath, True

End Sub

Can you point me to what is causing this error.  I'm trying to import an existing excel spreadsheet into a new table in Access 2010.

Thanks

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-03-12T14:30:17+00:00

    I tried using acspreadsheetTypeExcel12 and get the same error.  When I use acspreadsheetTypeExcel12Xml I get run-time error '3170' Could not find installable ISAM.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-03-11T17:19:06+00:00

    Isn't acSpreadsheetTypeExcel9 for xls files.  I believe you need to use acSpreadsheetTypeExcel12 or acSpreadsheetTypeExcel12Xml for xlsx files (I believe it is the later that is the correct constant to use).

    Sadly MS has done a horrible job keeping their help files up-to-date and many of these are unknown unless you have researched such a problem and found the answer.

    Was this answer helpful?

    0 comments