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

AccessDatabaseEngine.exe /passive The /passive switch tells the installer to run with progress bars but not to display error dialogs. It forces the installation to complete, allowing the 32-bit DLLs to coexist with the 64-bit ones. Both providers will now be registered.

The solution is the . This package contains the Microsoft.ACE.OLEDB.12.0 provider. The catch is that Microsoft distributes this in two separate architectures (32-bit and 64-bit), and installing the wrong one can break existing Office installations. download microsoft.ace.oledb.12.0 provider for both 64-bit

Do not use /quiet on both. The second installer will detect the first and fail silently. Use /passive for the second architecture. Alternative Command Line Sequence (For advanced users) If /passive fails, try this on a clean machine (no Office): AccessDatabaseEngine

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Data\Sales.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES"; This is the advanced section. If your search for "download microsoft.ace.oledb.12.0 provider for both 64-bit" brought you here, this is what you need. The solution is the

# 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()

AccessDatabaseEngine_x64.exe /quiet

Now that you have successfully downloaded and installed the Microsoft.ACE.OLEDB.12.0 provider for both 64-bit and 32-bit environments, that frustrating "provider not registered" error should be a thing of the past.