michd
asked on
Could not find installable ISAM. Excel 2007
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:
Microsoft.Jet.OLEDB.4.0
Microsoft.ACE.OLEDB.12.0
I also modified the registry entry for: HKEY_LOCAL_MACHINE/SOFTWAR E/Microsof t/Jet/4.0/ Engines/Ex cel to point to C:\WINDOWS\System32\msexce l40.dll like my localhost is setup.
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:
Microsoft.Jet.OLEDB.4.0
Microsoft.ACE.OLEDB.12.0
I also modified the registry entry for: HKEY_LOCAL_MACHINE/SOFTWAR
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;"""
conExcel.Open strConnectionExcel
' Load ADO Recordset with Excel Data
set rsExcel = Server.CreateObject("ADODB.Recordset")
rsExcel.Open ("SELECT * FROM [Sheet1$]"), strConnectionExcel
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I also updated the Excel 8.0 to Excel 12.0...
from this:
strConnectionExcel = "Provider=Microsoft.ACE.OL EDB.12.0;D ata Source=" & strWDir & ";Extended Properties=""Excel 8.0; HDR=Yes;"""
to this:
strConnectionExcel = "Provider=Microsoft.ACE.OL EDB.12.0;D ata Source=" & strWDir & ";Extended Properties=""Excel 12.0; HDR=Yes;"""
from this:
strConnectionExcel = "Provider=Microsoft.ACE.OL
to this:
strConnectionExcel = "Provider=Microsoft.ACE.OL
Have you tried using an xlsx file instead?
Also try writing the full path in one line like
Provider=Microsoft.ACE.OLE DB.12.0;Da ta Source=c:\TestWorkbook.xls x;Extended Properties="Excel 12.0;HDR=YES;"
Also try writing the full path in one line like
Provider=Microsoft.ACE.OLE
ASKER
Tried that and that too did not work. I am currently looking at the drivers that both computers have.
ASKER
Well I got the Microsoft Drivers to be the same on both boxes, but I am still getting the ISAM error when I try to run this through a web server browser versus my local box.
set conExcel = Server.CreateObject("ADODB .Connectio n")
strConnExcel = "Provider=Microsoft.ACE.OL EDB.12.0;D ata Source=//mefspr01/groups/e veryone/ac ct/AMS Working/Automation_Commiss ion.xlsx;E xtended Properties=""Excel 12.0; HDR=Yes;"""
conExcel.Open strConnExcel
set conExcel = Server.CreateObject("ADODB
strConnExcel = "Provider=Microsoft.ACE.OL
conExcel.Open strConnExcel
Can you try mapping a drive?
ASKER
Man this stinks!!! Still doesn't work. I am about to see if I can switch to csv vs xls.
set conExcel = Server.CreateObject("ADODB .Connectio n")
strConnExcel = "Provider=Microsoft.ACE.OL EDB.12.0;D ata Source=I:\Everyone\Acct\AM S Working\Automation_Commiss ion.xls;Ex tended Properties=""Excel 12.0; HDR=Yes;"""
conExcel.Open strConnExcel
set conExcel = Server.CreateObject("ADODB
strConnExcel = "Provider=Microsoft.ACE.OL
conExcel.Open strConnExcel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER