I'm using Access 2003 and Excel 2003. I can link or import an Excel
table fine through the menu. But when I do this through code I get an
error: "Run time error 3170. Could not find installable ISAM." I am
able to import and link Excel tables using the Access menu. Here is the
part of my code that's causing the error:
Set db = CurrentDb
'Get file name
strImportFile = [Forms]![fm_Import]![txtFile].Value
Set tblImportTable = db.CreateTableDef("FLOWIMPORT")
With tblImportTable
..Connect = "Excel 11.0;HDR=YES;IMEX=2;DATABASE=" + strImportFile
..SourceTableName = "INFLOW$"
End With
db.TableDefs.Append tblImportTable
Can anyone help?
TIA |