Error 3170: Couldn't find installable ISAM

[GeorgeMar]

I am getting the error 3170: Couldn't find installable ISAM when trying to
access an Excel file with something like:

tdf.connect="Excel 2003;DATABASE=C:\test.xls"

The error occurs at:

db.tabledefs.Append tdf

I have searched all over this newsgroup and tried all the suggestions, such
as, registering regsvr32 msexcl40.dll. I have even updated the installation
of Access 2003.

Any suggestions?

many thanks
George

 

[DeepField]

Just by coincidence, I am having the same error, but I am trying to link an
Access table to a SQL (not Excel) table. The connection works as long as I am
not linking to a table:

Dim conn As New ADODB.Connection
Dim dbus As New ADODB.Recordset

cstc = "Provider=SQLOLEDB;" & _
"Data Source=10.4.21.254;" & _
"Initial Catalog=Tablero de ControlSQL;" & _
"Network=DBMSSOCN;" & _
"User Id=user;" & _
"Password=pwd"

conn.Open cstc
dbus.Open "Select * from usuarios where usuario = '" & usuario & "'", conn,
adOpenDynamic, adLockOptimistic

But when I try to link to tables I get an error 3170 on the .append line:

db.TableDefs.Delete "Categorias"
Set tabla = db.CreateTableDef("Categorias")
tabla.Connect = cstc
tabla.SourceTableName = "dbo.Categorias"
db.TableDefs.Append tabla

Please help us out...

DeepField