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

I am running Windows Server 2003.  I have SQL Server 2005 installed and I have Access 2007 installed.

I have two SQL stored procedures to import excel files into SQL tables.  The one that imports files with the older .xls extension use the Access JET provider.  That sp is working just fine.  The other sp for importing the newer .xlsx files fails.  The ASP.NET executing the sp returns:  Ad hoc access to ole db provider.... bla bla bla.  

I had the same problem with using JET.  I just had to go to the registry and navigate to HKLM\software\microsoft\microsoft sql server\mssql.1\providers\microsoft.jet.oledb.4.o and create a key called Disallowadhocaccess.

HOWEVER, I don't have any registry path under sql server that has a key named like Microsoft.Ace.  That makes me think that I don't have that provider installed (even though office 2007 installed).  

Can anyone tell me ... do I need to download and install that provider or should I just make a registry path?  Note that under sql server I have MSSQL.1 through MSSQL.5.
Question by:santaspores1
    LVL 20

    Accepted Solution


    Author Comment

    I don't have any registry path that leads to \providers\Microsoft.Ace.OLEDB.12.0
    LVL 35

    Assisted Solution


    Author Comment


    Thanks you guys.  

    This isn't the issue though.  Please ignore the "Ad hoc access to ole db provider..." message.  The problem is that I do not seem to have the ACE provider installed.  And I am referencing that provider when importing xlsx documents.  NOTE that everything works just fine when I use the JET provider... but I also need to be able to use the ACE provider.
    LVL 83

    Assisted Solution


    Author Closing Comment

    Thank you for your help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video discusses moving either the default database or any database to a new volume.

    779 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

    15 Experts available now in Live!

    Get 1:1 Help Now