472,371 Members | 1,586 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,371 software developers and data experts.

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 1751

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Karl Irvin | last post by:
In the module below, I get a "Could not find installable ISAM" error on the tdf.refresh link. The NewConnection refers to a valid database/table. My References include VBA, Access 9.0 Object...
2
by: DBQueen | last post by:
I received a "Could Not Find Installable ISAM" error (#3170) when using Docmd.TransferDatabase to export a table from one database to another - Set wrkDefault = DBEngine.Workspaces(0)...
2
by: Horst Walter | last post by:
I am using C# / ADO.NET to create an Excel sheet: This connection string works: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;"; This...
6
by: Robert Lawson | last post by:
I continue to get the below error message when trying to load a aspx file. Could someone please point me in the right direction for solving this? I'm trying to access an access data base and I'm...
1
by: Roger Twomey | last post by:
I have a form that allows a user to upload a microsoft Excel Spreadsheet. (I am testing with one created in Excel 2000) The spreadsheet is uploaded correctly. It is then supposed to be read...
2
by: ibeetb | last post by:
When using ADO.NET, here is my code to bring in a table from EXCEL: Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _ ...
1
by: Job Lot | last post by:
i am querying excel file as follows Dim conn As New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source='" & "C:\Temp\SSPortfolio.xls" & " '; " & _ "Extended Properties=Excel...
1
by: sdc248 | last post by:
Hi: I got an error message when I am trying to have a stored procedure import a table from an excel file. It's a SQL Server 2005 and I have enable the Ad Hoc Distributed Queries option. The query...
7
Walt in Decatur
by: Walt in Decatur | last post by:
I'm trying to use this method to copy an range in Excel workbook that is closed to the one that's open. I'm using the following code, which gets the "Can't find installable ISAM" error when I get to...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
2
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
0
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.