Posted on 2012-09-14
Last Modified: 2012-09-17

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)?
Question by:santaspores1
    LVL 84

    Accepted Solution

    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.

    Author Closing Comment

    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.

    Author Comment

    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.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now