Microsoft ACE OLEDB 12.0

This OLE DB Provider is provided by Microsoft. The main functionality of the provider is contained in the file ACEOLEDB.DLL.

Include "Provider=Microsoft.ACE.OLEDB.12.0" in the connection string to use this provider.

Description

This driver was first released with Office 2007. It is possible to use the Microsoft.ACE.OLEDB.12.0 to connect to old .xls (Excel 97-2003) workbooks as well. The driver is available in both 32 bit and 64 bit versions.

Please Note!
There are some reported problems with the "Microsoft Access Database Engine 2010 Redistributable" package that seems to arise when using 64 bit windows and 64 bit office 2010 or above.
The reported solution is to install the "2007 Office System Driver: Data Connectivity Components" instead.
Read more in this article.

Download

This OLE DB Provider, Microsoft ACE OLEDB 12.0, can be downloaded here.

Connection Strings

The Microsoft ACE OLEDB 12.0 provider can be used to connect to the following data sources by using the following connection string references:

ExcelExcel 97Excel 2000Excel 2002Excel 2003Excel 2007Excel 2010Excel 2013AccessAccess 97Access 2000Access 2002Access 2003Access 2007Access 2010Access 2013DBF / FoxProSharePoint

Providers

CData ADO.NET Provider for Excel Microsoft Jet OLE DB 4.0 CData ADO.NET Provider for SharePoint Microsoft Access ODBC Driver Microsoft Access accdb ODBC Driver .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC .NET xlReader for Microsoft Excel Microsoft Excel ODBC Driver Microsoft Excel 2007 ODBC Driver Camelot .NET Connector for Microsoft SharePoint Microsoft dBASE ODBC Driver CData ODBC Driver for SharePoint 2015

Articles

read all »
Jet for Access, Excel and Txt on 64 bit systems The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Open a password-protected Excel workbook Formating Rules for Connection Strings Connection Strings Explained Store Connection String in Web.config Connection Pooling The Provider Keyword, ProgID, Versioning and COM CLSID Explained Store and read connection string in appsettings.json SQL Server Data Types Reference