469,943 Members | 2,352 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,943 developers. It's quick & easy.

Error linking Excel table through VBA

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?

Nov 13 '05 #1
0 1189

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by c duden | last post: by
6 posts views Thread by oyk | last post: by
4 posts views Thread by franc sutherland | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.