64位机器 ADO连接EXCEL时出错

64位机器使用 ADO连接EXCEL时会出现  System.InvalidOperationException: 未在本地计算机上注册“Microsoft.Jet.OLEDB.4.0”提供程序

 

网上找到方案为：

如果Jet引擎正常（打开"ODBC"，转到“驱动程序”选项卡，有没有JET引擎），通过执行命令 cscript C:/inetpub/adminscripts/adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 将64位的IIS转为32位方式运行，再用.Net Framework注册IIS，在IIS Web服务扩展中，激活ASP.NET v2.0.50727 (32bit)，重启IIS。
FROM:
Enable 32-bit Server Applications on 64-bit Machines ASP.NET applications that use TX Text Control .NET Server must be compiled for 32-bit platforms (see this article). IIS must be configured to execute these 32-bit applications. Generally, all applications will be executed in 64-bit mode.
a). Enable IIS's 32-bit support Open a command prompt and type in the following command: cscript %SYSTEMDRIVE%/inetpub/adminscripts/adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 This command enables the 32-bit mode in IIS. b). Install t