Download Microsoft.ace.oledb.12.0 Provider For Both 64-bit -

Most users only need one architecture. Here is how to do it cleanly.

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

After installation, the provider will be registered in the OLE DB list. You can verify via:

Your connection string will look like this: download microsoft.ace.oledb.12.0 provider for both 64-bit

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Data\Sales.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";

By default, Microsoft prevents side-by-side installation of different bitness versions of the ACE provider. To bypass this, use the passive or quiet command-line switch.

64-bit PowerShell:

# Run this in C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
$conn = New-Object System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\test.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES'")
$conn.Open()
Write-Host "64-bit connection successful"
$conn.Close()

32-bit PowerShell:

# Run this in C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe
$conn = New-Object System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\test.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES'")
$conn.Open()
Write-Host "32-bit connection successful"
$conn.Close()

If both scripts run successfully, you have successfully installed both providers. Most users only need one architecture

By design, Microsoft prevents side-by-side installation of both bit versions of the Access Database Engine. The installer checks for existing Office components and blocks installation.

| Architecture | Direct Download Link | | :--- | :--- | | 64-bit | AccessDatabaseEngine_X64.exe | | 32-bit | AccessDatabaseEngine.exe |

Note: These links point to the 2016 version, which is the latest standalone provider fully supporting ACE 12.0.

This is the most critical step. If you already have 32-bit Office installed on your computer, running the 64-bit installer directly will fail with an error message saying you cannot install 64-bit Office components alongside 32-bit Office. Scenario B: You only have 32-bit tools or 32-bit Office

Option A: You do not have Office installed (or you have 64-bit Office) Simply double-click the downloaded AccessDatabaseEngine_X64.exe file and follow the prompts.

Option B: You have 32-bit Office installed (Common Scenario) If you have 32-bit Microsoft Office but need the 64-bit driver for a server application (like SQL Server Integration Services), you must perform a Silent Install via the Command Prompt to bypass the version check.

Microsoft's Rule: You cannot install both the 32-bit and 64-bit versions of the standard ACE provider side-by-side using the standard GUI installer. If you try, you will see: "You cannot install the 64-bit version of Microsoft Access Database Engine because you have 32-bit Office installed."

This is the number one reason people search for "download microsoft.ace.oledb.12.0 provider for both 64-bit".