I have seen the solutions to this problem, but I can't get any of them to work.
I have an asp page that works when I run the page through my localhost, but as soon as I try to run it on my web server it fails.
On a side note, I have tried both of the following:
I also modified the registry entry for: HKEY_LOCAL_MACHINE/SOFTWAR
cel to point to C:\WINDOWS\System32\msexce
l40.dll like my localhost is setup.
strWDir = "//mefspr01/groups/everyone/acct/AMS Working/Automation_Commission.xls"
set conExcel = Server.CreateObject("ADODB.Connection")
strConnectionExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strWDir & ";Extended Properties=""Excel 8.0; HDR=Yes;"""
' Load ADO Recordset with Excel Data
set rsExcel = Server.CreateObject("ADODB.Recordset")
rsExcel.Open ("SELECT * FROM [Sheet1$]"), strConnectionExcel