XP - Linking Access to Excel - Error 3170 Could not Find Installable ISAM

R

Raul Archuleta

Hello.. Using the code below I am attempting to create a
link between Access XP (2002) and Excel XP. In the
Connect Property shown below I am attempting to use Excel
9.0 or Excel 10.0 as my Database type specifier, since
current documentation only provides examples up to Excel
97 (Excel 8.0). I am getting a 3170 ISAM error? Does
anyone have advice as to what my Database type specifier
should be for Excel XP if I maybe am doing something
wrong? thanks for the help..

Set tdefLinked = dbsTemp.CreateTableDef("ExcelTable")
tdefLinked.Connect = "Excel
9.0;DATABASE=C:\Excel\Q1Sales.xls"
tdefLinked.SourceTableName = "Q1Sales"
dbsTemp.TableDefs.Append tdefLinked
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 3170: Couldn't find installable ISAM 1
ISAM Error 3170 0
Could not find installable ISAM. (Error 3170) 2
Project 2010 "Project has stopped working" error when attempting to import from Excel 0
Access error 3170 (ISAM) 1
error 3170 could not find installable ISAM 0
Win XP Access 2007 "Could not find Installable ISAM" error 0
2007 Could not find installable ISAM (Error3170) 1

Top