On a 64-Bit SharePoint system you will normally get the "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." message if you try to connect to Office data like Excel or Access or SQL Server via OLEDB. That's because no 64-Bit MDAC driver is installed by default. To connect Microsoft Office 2010 and 2013 data directly to SharePoint lists, without Office installed on the server, you have to install the Office System Driver - Data Connectivity Components. If installed you can connect custom lists directly to Access, Excel or other Office data using the Layer2 Business Data List Connector for SharePoint (BDLC).

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Please note, that the following driver can be installed on a 64-bit system only if no 32-bit Office components are already installed, including 32-bit versions of MS Project and SharePoint Designer.
You have to completely uninstall these components to install these driver.

This download will install a set of components that can be used by non-Microsoft Office applications to read data from and write data to 2010 Office system files such as Microsoft Access 2010 (mdb and accdb) files and Microsoft Excel 2010 (xls, xlsx, and xlsb) files. Connectivity to text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.

THIS IS THE ONLY 64-Bit ODBC/OLEDB/EXCEL/ACCESS/SQL DRIVER AVAILABLE NOW!

To install this download:

1.Download the file by clicking the Download button and saving the file to your hard disk.

2.Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.

3.Follow the instructions on the screen to complete the installation.

To use this download:

Select OLEDB as Provider.

If you are using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”, e.g.

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\northwind.accdb;User Id=admin;Password=;"

to access the sample Northwind database at the given location.

If you are connecting to Microsoft Office Excel data, add “Excel 12.0” to the Extended Properties of the OLEDB connection string.

If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file

If you are application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file

To remove this download:

To remove the download file itself, delete the file AccessDatabaseEngine.exe

1.On the Start menu, point to Settings and then click Control Panel.

2.Double-click Add/Remove Programs.

3.In the list of currently installed programs, select “Microsoft Access database engine 2010” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.

4.Click Yes or OK to confirm that you want to remove the program.  

 

 

Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

The Layer2 Business Data List Connector is definitely the best add-on for Microsoft SharePoint!

Related Contacts
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
sales@layer2.de

Please note that the 011 exit code must be dialed first for all international calls made from the USA , Canada and Australia.

News

Layer2 Business Data List Connector for SharePoint V6 released with new Exchange Data Provider

Layer2 has announced a new version 6 of the Business Data List Connector (BDLC) that easily integrates external data with SharePoint. The connector comes with additional data providers and a new custom field mapping feature.

Layer2 Business Data List Connector for SharePoint V5 Released To Close Gaps With External Data Integration

Layer2 has announced V5 of the SharePoint Business Data List Connector that connects almost any external corporate data source with native SharePoint lists and closes many gaps that still exist with SharePoint data integration.
Related Downloads
NoDoc Image

Business Data List Connector PAD File

This XML-based PAD file offers a product description for resellers to download and publish.
PDF Image

Customer Solution Case Study: WealthVest Marketing Benefits From SharePoint Data Integration Using Layer2 Business Data List Connector

"By using the Layer2 Business Data List Connector for SharePoint app we can provide native SharePoint lists as a simple, easy-to-use, and familiar interface to manage mission critical business data."
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

How to connect ANY external data source directly to native SharePoint lists?

Download this step-by-step introduction to the Layer2 Business Data List Connector (BDLC) for SharePoint.
PDF Image

How to integrate SAP data with SharePoint via NetWeaver & OData

You simply have to enter an URL to the data collection to integrate and sync SAP data with native SharePoint lists.
PDF Image

Produktflyer: Business Data List Connector for SharePoint

Productflyer (PDF) in English for download.
PDF Image

Testimonial: How the US Defense Contract Management Agency (DCMA) integrates SharePoint with Oracle using BDLC

"Layer2 Business Data List Connector (BDLC) software provides a powerful mechanism for surfacing external data through lists, and drastically improves platform stability and development cycles."
Related Links

Are you looking for partners in your region?

Please find a local partner here.

BDLC works with NINTEX Workflow 2010 for SharePoint

Start NINTEX Workflows while external data changes.

Layer2 BDLC for SharePoint Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join our group to share your experience.

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.