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))
            {
                    connection.Open();               
            }

Open in new window

corebizAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

golfDoctorCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
0
golfDoctorCommented:
Yes, you don't likely have the Excel 2007 drivers installed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.