Microsoft ACE OLEDB 12.0
This OLE DB Provider is provided by Microsoft.
The provider is contained in the file ACEOLEDB.DLL.
Include "Provider=Microsoft.ACE.OLEDB.12.0" in the connection string to use this provider.
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.
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.
OLE DB Provider (Microsoft ACE OLEDB 12.0) can be downloaded here.
The Microsoft ACE OLEDB 12.0 provider can be used to connect to the following data sources:
To see available connection options, navigate to the connection strings reference by the above links.