Troubleshooting OLE DB Provider Microsoft.ACE.OLEDB.12.0 is not registered Error when importing data from an Excel 2007 file to SQL Server 2008

By: Editor
Jan 12, 2011

Page: 1/2

Introduction

While running an SSIS Package to import data from an Excel 2007 file to an SQL Server Table I happen to receive the below mentioned error during the SQL Server Integration Service (SSIS) package execution. This error is received even when you are trying to import data from an Excel 2007 file to SQL Server 2008 R2 using integration services.

Error Message

Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.
The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered.
Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154
Description: "Class not registered".

On further analysis I discovered that one will get the above mentioned error when Microsoft Office 2007 is not installed on the machine where SQL Server 2008 Integration Services is installed.

In order to import data from Microsoft Office Excel 2007 file formats such as .xls, .xlsx and .xlsb or from Microsoft Office Access 2007 file formats such as .mdb or .accdb files one needs install a set of components that can be used to facilitate transfer of data between 2007 Microsoft Office System files and non-Microsoft Office applications.

Instead of install Microsoft Office 2007 on the machine where SQL Server 2008 is installed you can simply go ahead and download 2007 Office System Driver: Data Connectivity Components file and then install the same on the server where SQL Server 2008 is running.

Important Note

If you are trying to import data from Microsoft Office Excel 2010 file formats or from Microsoft Office Access 2010 file formats then one need to install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications. Instead of install Microsoft Office 2010 on the machine where SQL Server 2008 or SQL Server 2008 R2 is installed you can simply go ahead and download Microsoft Access Database Engine 2010 Redistributable file and then install the same on the server where SQL Server 2008 or SQL Server 2008 R2 is running. 

Steps to install Microsoft Office Access Database Engine 2007

1. Accept the License Agreement and click Next, to continue with the installation.

Microsoft Office Access Database Engine 2007


2. Choose where to install Microsoft Office Access Database Engine 2007 and then click Next to continue with the installation.

Install Microsoft Office Access Database Engine 2007   

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article

Click on Next Page to continue reading rest of the article…


Next Page..



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."