Microsoft ACE OLEDB 12.0

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

Coding

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

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:

AccessAccess 2000Access 2002Access 2003Access 2007Access 2010Access 2013Access 97DBF / FoxProExcelExcel 2000Excel 2002Excel 2003Excel 2007Excel 2010Excel 2013Excel 97SharePoint

To see available connection options, navigate to the connection strings reference by the above links.

Not the right library?

Try search the kb articles, Q&A content and every connection string here.

Or go to the Q&A forums where you can ask questions.

Browse every article in the knowledge base. Start over in the connection string reference.

Providers

Articlesread all »