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

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))

Open in new window

Who is Participating?
golfDoctorConnect With a Mentor Commented:
Likely due to not having the necessary drivers installed on the server.   See here also:
corebizAuthor Commented:
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.
Yes, you don't likely have the Excel 2007 drivers installed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.