Search notes:

Microsoft OLE DB Provider for Microsoft Access database engine

Download Microsoft Access databases engine 2010

This provider can be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=13255
The link allows to download either or both of AccessDatabaseEngine.exe and AccessDatabaseEngine_X64.exe.
When AccessDatabaseEngine_X64 is executed, it installs (among others?) ACEOLEDB.DLL (in %CommonProgramFiles%\microsoft shared\OFFICEn) and STSLIST.DLL (in C:\Program Files\Microsoft Office\Office14)
After installing, this provider can then be removed again by deinstalling Microsoft Access database engine 2010.

Correct Extended Properties

Extended Properties=
Excel 97-2003 Workbook (.xls) "Excel 8.0"
Excel 2007-2010 Workbook (.xlsx) "Excel 12.0 Xml"
Excel 2007-2010 Macro-enabled workbook (.xlsm) "Excel 12.0 Macro"
Excel 2007-2010 Non-XML binary workbook (.xlsb) "Excel 12.0"
See also the program I have written to test Excel connection strings.

Data types

Supported data types seem to be:
Bit
Byte
Short (Same is Integer)
Long
Currency
Single
Double (Same as Float)
DateTime
Text
Memo (Same as LongChar)
(ODBC data type) Char same as Text
Float Same as Double
Integer Same as Short
LongChar Same as Memo
Date date format

Documentation

There doesn't really seem to be any documentation for this provider (social.msdn.microsoft.com/...)

See also

OLE DB Provider
OLE DB Provider for Microsoft Access database engine: connection string
Creating a new Excel workbook and worksheet with OLE DB, SQL and C#
The ProgId for the Access Database engine provider is Microsoft.ACE.OLEDB.12.0.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine
The transfer… methods of the doCmd object in Access' Object Model
Access database engine of Access 2013 prevents the installation of a 64-bit Office version
The MS-Access method Application.CurrentDb() establishes a hidden reference to the Microsoft Office Access Connectivity Engine object library in an MS-Access database.

Links

Accessing Excel files on a x64 machine

Index