64位Server 2008中的Excel 2010错误 [英] Excel 2010 error in 64-bit Server 2008

问题描述

我有一个用VB 6.0编写的应用程序.在具有Excel 2010的Windows 7 32位系统中，它可以正常工作.但是，与具有Excel 2010的Windows Server 2008 64位系统一起运行时，却出现错误.

以下是我遇到错误的那一行.

Hi,

I have an application written in VB 6.0. It is working fine in Windows 7 32-bit with excel 2010. But getting error while running the same with Windows Server 2008 64-bit with excel 2010.

Below is the line in which i am getting the error.

conExcel.Open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & "E:\Book1.xlsx" & ";" & _ "Extended Properties=""Excel 12.0;HDR=YES;"""

我得到的错误如下.

"运行时错误3706-可能找不到提供程序.它可能未正确安装".

最好的问候

Janizar Akthar T

And the error i am getting is as below.

"Runtime error 3706 - Provider may not be found. It may not be properly installed".

Best Regards

Janizar Akthar T

推荐答案

将其重新编译为32位，并且可以正常工作-没有64位Access驱动程序，因此它抱怨缺乏.
另一个解决方案是改为使用Excel互操作.

Recompile it for 32 bit, and it will work - there are no 64 bit Access drivers so it is complaining about the lack.
The other solution is to use Excel interop instead.

这篇关于64位Server 2008中的Excel 2010错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！