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)?
santaspores1Asked:
Who is Participating?
 
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
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.

All Courses

From novice to tech pro — start learning today.