Could not find the installed ISAM

Question

0.00/5 (No votes)

See more:

C#

strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" + "D:\\SubjectMaster.xls" + "; Jet OLEDB:Engine Type=5;" +
                                                 "Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\";";

                                        (OR)

strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                    "Data Source=" + "+textBox1.Text+" + "; Jet OLEDB:Engine Type=5;" +"Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\";";

I am using the above connection string for my application.

Error : Could not find the installed ISAM

I installed Msexecl40.dll also.

can anyone help me to solve this problem.

Posted 19-Feb-14 21:38pm

Karthik Achari

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2014-02-19T21:54:00

Solution 1

Normally, this is an indication that your connections string is wrong: try removing the "Jet OLEDB:Engine Type=5;" part and see if it goes away.

Posted 19-Feb-14 21:54pm

OriginalGriff

Comments

Karthik Achari 20-Feb-14 4:11am

Again same error was occured

Karthik Achari 20-Feb-14 4:26am

OleDbConnection cnCSV = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + textBox1.Text + "; Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";");

when i use this connection string and click on import button.It clears the data from grid view.

Can you help me to solve this issue.

OriginalGriff 20-Feb-14 4:38am

That you called it an "import button" may be significant here - I'm just guessing that it reads data, but doesn't find any. So it clears the existing data and replaces it with empty space...

Karthik Achari 20-Feb-14 4:42am

private void button2_Click(object sender, EventArgs e)
{

OleDbConnection cnCSV = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + textBox1.Text + "; Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";");
//OleDbConnection cnCSV = new OleDbConnection(strConnectionString);
OleDbDataAdapter das = new OleDbDataAdapter("Select *from [Sheet1$]", cnCSV);
DataSet da = new DataSet();

das.Fill(da);
dataGridView1.DataSource = da;

}

This is the code what i have used for my application.

OriginalGriff 20-Feb-14 4:58am

Yes - and it deletes all the existing data in your DGV and replaces it with everything it read from the file.
So the next thing to do is start looking at the data file.
I use very similar code (except mine is for XLSX files and uses Excel 12) and it works fine.

Karthik Achari 20-Feb-14 5:06am

i am using .Netframework 2.0

OriginalGriff 20-Feb-14 5:17am

Yes...and? I don't see the relevance.

Karthik Achari 20-Feb-14 5:53am

Thanks for your support.

OriginalGriff 20-Feb-14 6:02am

You're welcome!