Note: Both files are listed on the same Microsoft download page. Look for the "Choose your download" section and select the appropriate version.
Certain environments (Windows Server 2016+, Windows 10 Enterprise) allow both if you accept the warning. This is not recommended for production due to instability.
If /passive fails, try this on a clean machine (no Office): download microsoft.ace.oledb.12.0 provider for both 64-bit
# Install 64-bit first
msiexec /i "AccessDatabaseEngine_x64.exe" /quiet
Instead of forcing both, identify the bitness of your calling application and install only that provider. Use virtual machines or containers to separate 32-bit and 64-bit workloads.
Most users only need one architecture. Here is how to do it cleanly. Note: Both files are listed on the same
Scenario A: You only have 64-bit tools (e.g., 64-bit SQL Server, 64-bit SSIS).
Scenario B: You only have 32-bit tools or 32-bit Office Most users only need one architecture
After installation, the provider will be registered in the OLE DB list. You can verify via:
Your connection string will look like this:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Data\Sales.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";