Could not find installable isam VB.NET excel 2016

Question

0.00/5 (No votes)

See more:

Guys help me. I need to export the excel file to datagridview. But Everytime i select opened the file via file dialog box, the error was come and says "COULD NOT FIND INSTALLABLE ISAM" Help me please. With using Microsoft.Jet.OLEDB.4.0 not the Microsoft.ACE.OLEDB.12.0. Thanks

What I have tried:

VB

Dim OpenFileDialog1 As New OpenFileDialog()
       Dim constr As String
       'Dim con As OleDb.OleDbConnection
       Dim con As OleDbConnection

       Try

           OpenFileDialog1.Filter = "Excel Files | *.xlsx; *.xls; *.xlsm;"

           If OpenFileDialog1.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
               Me.txtOpen.Text = OpenFileDialog1.FileName

               constr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" + txtOpen.Text + ";Extended Properties = Excel 8.0;HDR=Yes;IMEX=1"
               'constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + txtOpen.Text + ";Excel 12.0 Xml;HDR=YES"
               con = New OleDbConnection(constr)
               con.Open()

               cboSheet.DataSource = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
               cboSheet.DisplayMember = "TABLE_NAME"
               cboSheet.ValueMember = "TABLE_NAME"
           End If
       Catch ex As Exception
           MessageBox.Show(ex.Message)
       End Try

Posted 12-Apr-18 21:41pm

Ronnie Jimenez

Updated 16-Apr-18 15:47pm

Add a Solution

Comments

Richard MacCutchan 13-Apr-18 4:58am

Are you sure that the Jet and ACE drivers are installed on the system?

3 solutions

Solution 1

You have to ensure that the Jet driver is installed. But that is only available as 32-bit version. So your application must be build as 32-bit (target platform x86 and not Any CPU).

If possible use the ACE driver instead because Jet is deprecated since many years.

Posted 12-Apr-18 23:52pm

Jochen Arndt

Solution 3

Thank you! :) .................

Posted 16-Apr-18 15:48pm

Ronnie Jimenez

Comments

Maciej Los 17-Apr-18 6:36am

Please, delete such of content, because it isn't an answer. To say "Tahnk you", use "Have a Question or Comment" widget.
Cheers,
Maciej

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2018-04-13T09:53:00

You can't use Microsoft.Jet.OLEDB.4.0 within .xlsx files. You have to use Microsoft.ACE.OLEDB.12 instead.
See: Excel connection strings - ConnectionStrings.com[^]

To resolve your issue, check this: Jet for Access, Excel and Txt on 64 bit systems - ConnectionStrings.com[^]

For further details, please see: HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"[^]