• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2133
  • Last Modified:

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/SOFTWARE/Microsoft/Jet/4.0/Engines/Excel to point to C:\WINDOWS\System32\msexcel40.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;"""
conExcel.Open strConnectionExcel
 
  
' Load ADO Recordset with Excel Data
set rsExcel = Server.CreateObject("ADODB.Recordset")
rsExcel.Open ("SELECT * FROM [Sheet1$]"), strConnectionExcel

Open in new window

0
michd
Asked:
michd
  • 6
  • 3
2 Solutions
 
tbsgadiCommented:
0
 
michdAuthor Commented:
That is what I installed to load the Microsoft.ACE.OLEDB.12.0 Provider.
0
 
michdAuthor Commented:
I also updated the Excel 8.0 to Excel 12.0...

from this:
strConnectionExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strWDir & ";Extended Properties=""Excel 8.0; HDR=Yes;"""

to this:
strConnectionExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strWDir & ";Extended Properties=""Excel 12.0; HDR=Yes;"""
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
tbsgadiCommented:
Have you tried using an xlsx file instead?

Also try writing the full path in one line like

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\TestWorkbook.xlsx;Extended Properties="Excel 12.0;HDR=YES;"
0
 
michdAuthor Commented:
Tried that and that too did not work.  I am currently looking at the drivers that both computers have.
0
 
michdAuthor Commented:
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.Connection")
strConnExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=//mefspr01/groups/everyone/acct/AMS Working/Automation_Commission.xlsx;Extended Properties=""Excel 12.0; HDR=Yes;"""
            conExcel.Open strConnExcel

0
 
tbsgadiCommented:
Can you try mapping a drive?
0
 
michdAuthor Commented:
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.Connection")
strConnExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=I:\Everyone\Acct\AMS Working\Automation_Commission.xls;Extended Properties=""Excel 12.0; HDR=Yes;"""
conExcel.Open strConnExcel
0
 
michdAuthor Commented:
Any other thoughts?  I have postings out at Microsoft and nothing I try is working.  

I have tried re-registering the dll, checked the registry, and reload MDAC.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now