Skip to content

microsoft.ACE.oledb.12.0 error

subsci edited this page Jul 25, 2017 · 3 revisions

System.InvalidOperationException: 未在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序。

pls install 2007 Office system driver http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe

OR to check if you already have ACE on your system, run Powershell (both x64 and x86)

> (New-Object system.data.oledb.oledbenumerator).GetElements() | select SOURCES_NAME, SOURCES_DESCRIPTION

Turns out I had x64 ACE as revealed in PowerShell. So rather than blindly install, I changed the configuration in VS2015 LinqToExcel v1.11. I used Configuration Manager to explicitly build for x64; and that corrected the error.

Clone this wiki locally