Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2012-08-18
Medium Priority
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 30

Accepted Solution

Olaf Doschke earned 2000 total points
ID: 38308947
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: http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm

Bye, Olaf.

Author Closing Comment

ID: 38361656

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

580 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