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

  • Thread starter Thread starter Raul Archuleta
  • Start date Start date
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
 
Back
Top