I got below error when open the Excel connection in asp. Can someone please help me....
I have both the UAT and production environment on the same web server (only pointing to different folders), and it's so weird that the program works fine under UAT
So I assumed the problem is not related to the server configuation.
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.
strExConn = "Provider=Microsoft.Jet.OLEDB.4.0;" &
"Data Source=D:\web\temp\Upload_2.XLS;" &
"Extended Properties=""Excel 8.0;HDR=No;IMEX=1"""
set oExConn = Server.CreateObject("ADODB.Connection")
I'm using Excel 97 on the web server, does it require a different OLEDB verion
(this is my wild guess, but I don't think so)
I checked the path and file name of the the data source.