469,964 Members | 1,809 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Installable ISAM error when linking excel table into Access

I'm using Access 2003 and Excel 2003. All I'm trying to do is bring a
sheet from an Excel file (defined by the user) into Access as a table,
I dont care if it's linked or imported. However, 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 1637

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by DBQueen | last post: by
6 posts views Thread by Robert Lawson | last post: by
2 posts views Thread by ibeetb | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.