Could not find installable ISAM.

Question

0.00/5 (No votes)

See more:

Hi all,
I want to import data from Access to my datagridview in VB.net
when i import, it is error like this:Could not find installable ISAM

I've installed the accessdatabaseengine & I've compile my program as a 32-bit program but it still didn't work

Here is my source code for import from excel to datagridview:

What I have tried:

VB

Private Sub frm_watercolour_A155751_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            
    Public myconnection As String = "Provider=Microsoft.ACE.OLEDB.12.0;DataSource=C:DB_ARTBOX.accdb;Persist Security Info=False;"
    
            Dim mysql As String = "SELECT * FROM TBL_PRODUCT where FLD_PRODUCT_CATEGORY = 'WATERCOLOUR' "
            Dim mydatatable As New DataTable
            Dim myreader As New OleDb.OleDbDataAdapter(mysql, myconnection)
            myreader.Fill(mydatatable)
            grd_watercolour.DataSource = mydatatable
        End Sub

Posted 14-Oct-16 23:39pm

Member 12794883

Updated 15-Oct-16 2:52am

Wendelius

v2

Add a Solution

2 solutions

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 · 2016-10-15T02:52:00

Well...

A myconnection variable is type of String and stores connection string. Note: this is not OleDbConnection object! So, this line:

VB.NET

Dim myreader As New OleDb.OleDbDataAdapter(mysql, myconnection)

won't execute, as an OleDbDataAdapter[^] constructor accepts SelectCommand[^] and OleDbConnection.

To be able to get MS Access data, you have to:

create OleDbConnection[^] then open it
create OleDbCommand[^]
create OleDbDataReader[^] and fill it by executing OleDbCommand[^]
create DataTable[^] object and load[^] data into it
release resources (for example: close OleDbConnection)

That's all!

For further details, please see:
Accessing Microsoft Office Data from .NET Applications[^]
Connect to data in an Access database (Windows Forms)[^] - recommended!

Wendelius · Accepted Answer · 2016-10-14T23:47:00

Solution 1

It looks like the path to the Access database is wrong. If the database file is located in the root direcory of drive C, try the following

VB

Public myconnection As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\DB_ARTBOX.accdb;Persist Security Info=False;"

Also note the space in Data Source

Posted 14-Oct-16 23:47pm

Wendelius

Updated 14-Oct-16 23:48pm

v2

Comments

Member 12794883 15-Oct-16 5:55am

i've done what you've told but it still didnt work, it says 'coulnd not find file'

Wendelius 15-Oct-16 6:03am

Is the path correct? Is the ACCDB file located in C:\ ?

Member 12794883 15-Oct-16 6:45am

yup

Wendelius 15-Oct-16 7:11am

Do you get the error message "Could not find file" when you connect to the database or when you execute an SQL command? If this happens when executing a command, what is the SQL statement?

Member 12794883 15-Oct-16 9:14am

when I execute SQL command

Wendelius 15-Oct-16 11:48am

So you can connect but executing the statement fails. What is the SQL statement you try to execute?

Maciej Los 15-Oct-16 8:54am

Please, check my answer. There you'll find some details about your issue.

Maciej Los 15-Oct-16 6:14am

5ed!

Wendelius 15-Oct-16 6:27am

Thank you Maciej!