win7补丁kb4041678 32/64位

kb4041678补丁介绍

可以用于修复部分系统的SQL数据库出错问题。而且还能够快速的升级电脑系统安全。

使用方法

把excel20003表数据导入到MDB数据库中

sql命令语句

\"SELECT * INTO 表 FROM [Excel 8.0;DATABASE=C:\\1.xls].[Sheet1$]\"

卸载KB4041678 补丁,电脑重启之后,执行正常。

经过测试多台电脑都出现这种情况，请检查一下是什么原因

解决办法如下：

1.Find prior version (4.0.9801.0) of msexcl40.dll

2.Place in another directory. They suggest the application directory, but since in the next step you will modify registry to point to this older version, it can probably go anywhere.

64-bit Operating System

3.Update registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel\win32 to point to the location from step 2.

32-bit Operating System

4.Update registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel\win32 to point to the location from step 2.

32-bit , MS office 2003

5.Update registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel\win32old to point to the location from step 2.