Solved

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

Posted on 2009-07-08
3
767 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
two-way Authentication ASP 3 89
How to show result of a NULL value at random? 32 50
Query still returning duplicates 5 27
Button to go back 3 23
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
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 …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

813 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

14 Experts available now in Live!

Get 1:1 Help Now