Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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 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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

914 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

15 Experts available now in Live!

Get 1:1 Help Now