Could not find installable isam

Question

4.33/5 (2 votes)

See more:

Dear ,

I need to upload .xlsx file i.e office 2007 file in my database.

for reading this file i am using followong connection string

"Provider=Microsoft.ACE.OLEDB.12.0;"+"Data Source=" + fileName + ";"
+"Extended Properties=Excel 12.0;HDR=YES;";

But while opening connection i am facing the error "could not find installable isam".

To avoid this and read both files i.e office 200.3 and 2007 also what should i do ?

Please guide me.

Thank you.

Posted 3-May-11 20:35pm

Vivek Deshmukh

Updated 15-Mar-16 3:49am

Add a Solution

2 solutions

Solution 2

if the databse that you are using is MDB then
there is a way,just put the provider and database name not the database path(if it resides in the current directory) :)

LIKE this "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=YourDB.mdb;"

Posted 27-Apr-13 2:57am

Bhishma Anil Kajaria

Updated 27-Apr-13 3:00am

v3

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)

Vivek Deshmukh · Accepted Answer · 2011-05-03T20:57:00

Solution 1

It working..................

Import Excel 2007 from asp.net steps
Installed - AccessDatabaseEngine

connection sting should be like this....

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\excel\\ExcelImport_8-2009.xlsx;Extended Properties=\"Excel 12.0 Xml;HDR=NO;IMEX=1;\""

Hurray!!!!!!!!!!!!!!!!!

Here in connection string HDR=No means header row is not indication column name and HDR=YES means yes first row in excel sheet indicates columns.

Posted 3-May-11 20:57pm

Vivek Deshmukh

Updated 3-May-11 21:21pm

v2

Comments

OsoJames 10-May-13 9:52am

I am still having the same error, can you please help me out? I am using Excel 2010

Dharmesh Shriwastava 22-Sep-14 15:21pm

thanks

getvinay1988 14-Oct-14 3:50am

This worked for me, thanks!!

Member 4649476 18-Jun-16 6:22am

Not working for me

toyfercho 29-Aug-16 23:59pm

Really help me and worked for me also, interesting the same issues happened over the years,

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\excel\\ExcelImport_8-2009.xlsx;Extended Properties=\"Excel 12.0 Xml;HDR=NO;IMEX=1;\""

Mohan Prasath R 1-Dec-17 1:37am

Thanks a lot. It worked for me