Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyData\Spreadsheet.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES"; Summary Table AccessDatabaseEngine.exe Driver Name Microsoft.ACE.OLEDB.12.0 Architecture 32-bit (x86) Supported Formats .xlsx, .xlsm, .accdb, .xlsb
Microsoft generally prevents you from installing both the x86 and x64 versions of the Access Database Engine on the same machine. If you try to install the x86 version while 64-bit Office is present, the installer will block you. microsoft.ace.oledb.12.0 download x86
The is specifically required when your application or host environment (like Visual Studio, SQL Server Integration Services, or a legacy ERP) is running in a 32-bit process, regardless of whether your Windows OS is 64-bit. Provider=Microsoft
You can bypass this by running the installer via Command Prompt with the /quiet flag: AccessDatabaseEngine.exe /quiet Connection String Example Extended Properties="Excel 12.0 Xml