Using DAO to link a spreadsheet: ISAM error
Hi,
If I'm not mistaken, Access uses the Excel ISAM Driver to import or
link Excel spreadsheets. Sounds like Office/Access install didn't install
this driver. Can you verify? You might need to re-run the Office Setup to
install this (and other) drivers.
HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://www.*-*-*.com/ ~dashish )
---------------
Quote:
>When I use this code
> Set db = CurrentDB()
> Set tdf = db.CreateTableDef(strTable)
> With tdf
> .Connect = "Excel 97;" & "'" & strPath & "'"
> .SourceTableName = strBaseTable
> End With
> db.TableDefs.Append tdf
>to link an Excel worksheet to an Access mdb, I get the following error when
>I step into the Append tdf line:
>Couldn't find installable ISAM
>Why does this happen?
>Your help is appreciated.
