[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1670
  • Last Modified:

Microsoft.Ace.OLEDB.12.0

Hello,

I have a stored procedure in sql server 2005 (running on win server 2003) that uses Microsoft.Jet.OLEDB.4.0 to import an excel file.  It works brilliantly... for xls file.  To import the newer xlsx format files I believe that I need to use Microsoft.ACE.OLEDB.12.0.  The problem is that, even though I have office 2007 (with access 2007) installed on this machine, I don't think I have that provider (there is no registry path anywhere under HKLM\software\microsoft\microsoft sql server that contains a key referencing Microsoft.Ace.OLEDB.  

1.  How can I verify for sure that I do not have this provider installed?
2.  Is it safe to download (from MS) the "2007 Office System Driver: Data Connectivity Components" which contains "Microsoft Office Access database engine 2007" and install it on a server that already has sql server 2005 and office 2007 (I don't want to overwrite anything that will gimp things up)?
0
santaspores1
Asked:
santaspores1
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The Providers are generally listed under the ODBC reg key (in the SYSWOW section, if you're on a 64-bit machine), or you can look in the Program Files\Common Files\ Microsoft Shared directory for the ACEODBC.DLL file.

You can safely install that download on yourmachine. It should not cause any troubles. It's always good to make a backup of important items first, of course, and be prepared to restart the machine if needed.
0
 
santaspores1Author Commented:
Thank you LSMConsulting - I really appreciate that answer.  I have the dll, but have no registry entry for this provider.  So I think I will try the install and see if it creates the registry path I need.
0
 
santaspores1Author Commented:
Update for others:  I installed "2007 Office System Driver: Data Connectivity Components" as well as the latest service pack for it.  That worked.  I then had a registry path (under microsoft sql server\MSSQL.1\Providers for Microsoft Ace.  That took care of my issue.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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