C # throws an exception when you manipulate Excel: "The microsoft.ace.oledb.12.0 provider is not registered on the local computer"

In our development environment, the use of Excel to import data into the database, the compiled software is initially x86 way, initially did not find any problems, everything is normal;

Procedure to enter the process:

Later importing the file will read hundreds of g of data Import database, using the compiled X86 program is not normal, although I parse the file (. xml) from the data stream to XmlTextReader, but still run out of memory overflow (" System.OutOfMemoryException "How painful, tragic, helpless AH), later colleagues suggested that I will be the program compiled x64 after the problem really solved (our development machine 64G memory, hehe. ）

The problem of memory overflow after program improvement is resolved, but it appears: "microsoft.ace.oledb.12.0" Provider is not registered on the local computer;

The problem arises when we install Office X86, create a. udl file, view the link properties of the database, and then know that the error is here, download the Accessdatabaseengine_x64.exe, and install the prompt: "Require uninstall x86 office ", tragedy.

Code:

C # throws an exception when you manipulate Excel: "The microsoft.ace.oledb.12.0 provider is not registered on the local computer"