Unexpected error from external database driver (1)

因为微软2017/10/10更新,造成ODBC Excel Driver驱动报错:Unexpected error from external database driver (1)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1

有2种解决方案:

1.卸载微软的补丁:

KB4041681 (Windows 7)

KB4041676 (Windows 10)

KB4041693 (Windows 8)

2.更换数据库连接驱动:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyExcel.xls; Extended Properties=\"Excel 12.0;HDR = YES;

　更新完代码,要让客户安装2007 Office System Driver: Data Connectivity Components,驱动下载link