Could Not Find Installable Isam

Could not find installable ISAM with Excel

Using Microsoft.ACE.OLEDB.12.0 as the provider solves the problem.

Could not find installable ISAM

There's no 64 bit version of the Jet OLEDB drivers, so if you are running this on a 64 bit OS you might need to target x86 in your .NET application and not Any CPU:

Could not find installable ISAM while opening excel file with OLE driver

ERROR has been resolved automatically with no change in code at all. Just after login again to my account after taking a break it runs successfully:

EDIT:

I Put conn.Open() after connection string.

New Code is As Below:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim conn As OleDbConnection
        Try

            Dim dta As OleDbDataAdapter
            Dim dts As DataSet
            Dim excel As String
            excel = "C:\Users\ishfaq.babar\Downloads\aaa.xlsx"
            'Dim openfiledialog As New OpenFileDialog
            'conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excel + ";Extended Properties='Excel 12.0;'";")

            conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\ishfaq.babar\Downloads\aaa.xlsx;Extended Properties='Excel 12.0;HDR=YES;Persist Security Info=False'")
            conn.Open()
            'PrintLine('ok')
            ' conn.Close()
            dta = New OleDbDataAdapter("select * from [Sheet1$]", conn)
            dts = New DataSet
            dta.Fill(dts, "[Sheet1$]")
            ExcelGridData.DataSource = dta
            ExcelGridData.DataBind()
        Catch ex As Exception
            conn.Close()
        End Try
    End Sub

Read data successfully from excel file as below screenshot:

Result of data read from excel file

Cannot find installable ISAM error when trying to pull data into C#

I was able to get this to work by modifying the connection string to:

string con = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Joshua.cameron\Documents\BullenGrosvenorTest\EstatesITExportSpec.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES' ";

could not find installable isam exception when trying to read an Excel file with oledb

For .xlsx, it should be:

StrConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + srcFile + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";";

(Note the extra Xml part, the HDR=YES to indicate your file has headers, the IMEX=1 to treat all data as text and the repositioned semi-colon. You would need different connection strings for .xlsm and .xlsb files - see here)

could not find installable ISAM vb.net

You have a nasty syntax error in your connection string:

"'; Extend Poroperties="" Excel 16.0;HDR=No"" ")

Extend => Extended
Poroperties => Properties

This should be (set HDR to whatever is needed. Leave IMEX=1 for safety):

";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1;"""

Change it in:

Dim ConnectionString As String =
    "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & TextBox1.Text &
    ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"""

Or:

Dim ConnectionString As String =
    "Provider=Microsoft.ACE.OLEDB.16.0;Data Source=" & TextBox1.Text &
    ";Extended Properties=""Excel 16.0 Xml;HDR=YES;IMEX=1"""

Dim con_excel As New OleDbConnection(ConnectionString)

Note that TextBox1.Text must provide the full path to the Excel file.

Download and install the required Database engines (32bit or 64bit).

Microsoft Access Database Engine 2010 Redistributable

Microsoft Access Database Engine 2016 Redistributable

About the Compile mode:

Set Project properties => Compile => AnyCPU
Set VS Debug Mode => AnyCPU

---

Related Topics