VBA run-time error 3170: Could not find installable ISAM

[navi95]

Hello all you genius MS access users!

I am trying to get this simple code to work, I just wanted to import my "Kunden" table from a XLSX excel file with the following code:

DoCmd.TransferSpreadsheet acImport, Kunden, "e:\pizza program\kunden.xlsx", True

But i seem to be getting this runtime error 3170. Ive looked around on google, I saw some people mentioning that maybe dll files need registering?

Any comments would be awesome! Thanks

 

[Ranman256]

Also, Kunden must be in quotes. "Kunden"

You can install the isams via control panel, programs,Access repair/reinstall.
Make sure you check all. ODBC drivers,isams ,etc

 

[navi95]

Ha! I just managed to fix it! I realised that between "acimport, kunden" there should of been the spreadsheet type. So my working code looks like this now:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Kunden", "e:\pizza program\kunden.xlsx", True

Thanks

 

[navi95]

Also, Kunden must be in quotes. "Kunden"

yes! I noticed that afterwards too