467,207 Members | 1,340 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,207 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?
TIA

Nov 13 '05 #1
  • viewed: 1136
Share:

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
reply views Thread by hivdb2@gmail.com | 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.