asp having problem accessing excel 2002
 

asp having problem accessing excel 2002

good day,

I have an ASP(Classic) application that is retrieving data in Excel 2002.
The problem is it can't access the data in it. But previous versions of
excel have no problem. Is this a bug? Does microsoft already have a solution
for this?

Here is my code

' Create a server connection object
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "DBQ=" & Server.MapPath(exceldb) & ";" & _
"DRIVER={Microsoft Excel Driver (*.xls)};"
dim strConn
strConn = "DBQ=" & Server.MapPath(exceldb) & ";" & "DRIVER={Microsoft Excel
Driver (*.xls)};"

Any idea why this one is not working on Excel 2002?

Thanks