SQL - Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "XLLink_EXCELSPREADSHEET"

Posted on 2012-08-18
Last Modified: 2012-09-03
I try to create a link server, I get the above error. I do have 'Microsoft ACE OLEDB 12.0' as a provider for Linked Server
Any idea what went wrong?
Question by:tommym121
    LVL 29

    Accepted Solution

    Look into the bitness of the provider and the server in the first place, there are two providers for x86 and x64. You also might find a solution to the issue in this walkthrough:

    Bye, Olaf.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 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

    19 Experts available now in Live!

    Get 1:1 Help Now