
HKEY_CLASSES_ROOT\CLSID\3BE786A0-0366-4F5C-8FB8-95E3565CAF27 If present, the driver is ready. | Tool / Language | Connection string example | |----------------|---------------------------| | Python (pandas) | engine='access' or conn_str = r"DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=C:\data\file.accdb" | | PowerShell | $conn = New-Object System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\data\file.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES'") | | SQL Server (Linked Server) | Provider = 'Microsoft.ACE.OLEDB.12.0'; Data Source = 'C:\data\file.accdb' | | C# / .NET | @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\data\file.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=YES""" | Troubleshooting tips ❌ “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered” → You installed the 64-bit version, but your app is 32-bit (or vice versa). Reinstall the 32-bit driver using /quiet if needed.
❌ → Run the installer from a local drive (not a network path). Also, ensure no Office apps are open (Outlook, Excel, Word). ❌ → Run the installer from a local
Look for the file named: (that’s the 32-bit version) The 64-bit version is named AccessDatabaseEngine_x64.exe . Do not grab that unless you are 100% sure your toolchain supports 64-bit ACE. Step 2: Install normally (with one big exception) Run AccessDatabaseEngine.exe . The default install is straightforward. Do not grab that unless you are 100%
🔗 https://www.microsoft.com/en-us/download/details.aspx?id=13255 Extended Properties='Excel 12.0 Xml
If you’ve ever tried to work with .xlsx , .xls , or .accdb files outside of Excel or Access—especially in PowerShell , Python (pandas) , C# , or SQL Server Integration Services (SSIS) —you’ve likely encountered this error: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. The solution? The Microsoft Access Database Engine 2010 Redistributable (32-bit).
❌ → If you need to read .xlsx files, you don’t need this driver. But if you need to read .xls (older format) or Access .accdb , this driver is essential. Final recommendation Download and keep a copy of AccessDatabaseEngine.exe in your internal tools repository. Because Microsoft may eventually retire the 2010 download page, and this tiny 26 MB file unlocks years of legacy data access.
Go to the official Microsoft Download Center:
