I am trying to access a named range on an Excel spreadsheet (Excel 97), but I am getting an error "Couldn't find installable ISAM" during the connection Open(). I have tried completely uninstalling Office 97 and reinstalling, but still get the error. I've made sure that the MSEXCL35.dll is present - it is.

The following is my connection string:
Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.3.51;" & _
            "data source=D:\Development\BegASPNETdb\datastores\inven tory.xls;" & _
            "Extended Properties=Excel 8.0;"

Here is the complete code to Select the range "Items":

Sub Page_Load(Source As Object, E As EventArgs)
   Dim strConnection As String = "Provider=Microsoft.Jet.OleDb.3.51;" & _
            "data source=D:\Development\BegASPNETdb\datastores\inven tory.xls;" & _
            "Extended Properties=Excel 8.0;"
   Dim objConnection As New OleDbConnection(strConnection)

   Dim strSQL As String = "SELECT * FROM Items"
   Dim objCommand As New OleDbCommand(strSQL, objConnection)

   objConnection.Open()
   dgInventory.DataSource = objCommand.ExecuteReader()
   dgInventory.DataBind()
   objConnection.Close()
End Sub

The issue seems to be with the installation of the ISAM files. Any help is appreciated.

RanceR

Try this. It worked for me...

http://www.dbforums.com/t652424.html

Jim