Solved

How do I overcome the "Could not find installable ISAM. Excel 2007"

Posted on 2009-07-08
3
762 Views
Last Modified: 2012-05-07
I got the "Could Not  find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line.

-- Web Application
-- .Net 2.0
-- Testing using IIS 7.0 on Vista Ultimate
-- Office 2007 Enterprise Installed on machine.

Code works successfully when used in a Windows Application
string excelConnectionString =@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0 Xml;HDR=YES;""";

            using (OleDbConnection connection = new OleDbConnection(excelConnectionString))

            {

                    connection.Open();               

            }

Open in new window

0
Comment
Question by:corebiz
  • 2
3 Comments
 
LVL 16

Accepted Solution

by:
golfDoctor earned 500 total points
ID: 24802749
Likely due to not having the necessary drivers installed on the server.   See here also:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21306564.html?sfQueryTermInfo=1+could+excel+find+instal+isam
0
 

Author Comment

by:corebiz
ID: 24803096
Thank you for the response. I am trying to import an Excel 2007 file using the "Provider=Microsoft.ACE.OLEDB.12.0" in a Web Application. It works well when I am using an Excel 2003 using the "Provider=Microsoft.Jet.OLEDB.4.0". I have installed, all the necessary drivers in the server. In a Windows application this seems to work perfectly with both Excel 2007 and Excel 2003 files.
0
 
LVL 16

Expert Comment

by:golfDoctor
ID: 24803119
Yes, you don't likely have the Excel 2007 drivers installed.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now