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();
}
Software/Hardware used:
ASKED:
July 9, 2009 10:06 AM
UPDATED:
July 9, 2009 12:25 PM