请问如何安装OLEDB驱动？

Question

我使用oledb驱动去打开excel文件，代码：

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0\"");

结果提示：

计算机已经安装了Excel2016、Access2016，还需要装什么吗？

---

da jia hao!

Answer 1

Hi liubin,

你还需要添加下面的程序。

Microsoft Access Database Engine 2010

希望会帮到你。

Best Regards,

Jack

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

谢谢。我安装了之后发现还是不行。。。。

后来我将C#项目从“Any CPU”改为“X86”之后才好了。

这个引擎需要计算机安装Office套件吗？我的计算机上安装的是32位的Office。

我必须将C#项目设置为x86才行吗？因为这个C#项目是一个COM组件，用于其他程序，可能是32也可能是64位的，如果明确指定了32位，可能会给使用带来麻烦。

---

da jia hao!

Answer 3

Hi liubin,

感谢您的反馈。

我检查了下，我安装的office是64位的，然后我去用oledb去访问excel时不需要去改Any CPU.

所以我建议你看下是否可以安装office 64位的。

Best Regards,

Jack

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].