The "microsoft.ace.oledb.12.0" provider is not registered on the local computer

An error occurred while running, prompting that the "microsoft.ace.oledb.12.0" provider was not registered on the local computer.

The reason for this is that the 32-bit version of Office is installed on a 64-bit PC, so microsoft.ace.oledb.12.0 is also 32-bit, while Visual Studio is 64-bit, and the default build is a 64-bit program.

Workaround one: Download the 64-bit Microsoft Access 2010 Database engine.

http://www.microsoft.com/zh-cn/download/details.aspx?id=13255

When installing, be careful to uninstall the 32-bit version of Office that may already be installed

Workaround two: In the project properties of Visual Studio, change the build's platform target from any CPU to x86, so that the build is a 32-bit program.

The "microsoft.ace.oledb.12.0" provider is not registered on the local computer