Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
在做excel2007 导入时,报的错:“Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine”;
细察下来,是我操作系统为64bit所致。具体方法如下:
“Actually it is because you are running 64-bit windows and there are no MS Access drivers that run 64-bit. So to solve it you need to change your build configuration to x86. You can do that on the project properties dialog under "Compile>Advanced Compile Options...>Target CPU". Change it to "x86". Then clean and rebuild your solution. It should work like a charm now.”
reference:
http://social.technet.microsoft.com/Forums/en-US/office2007deploymentcompatibility/thread/cc10d906-0fd8-49ef-a1b0-45814bd70c55/