![](https://img.codepudding.com/202009/110419271325341.jpg)
Can you tell me how to solve?
CodePudding user response:
Connect ODBC to excel method call if there's any problemCodePudding user response:
There was a problem is in the call ODBC, upgrade system vulnerabilities today, after the success of the upgrade, cannot be read correctlyCodePudding user response:
When using the connection string to connect to Excel, can replace the JET with ACEWill: "the Provider=Microsoft. Jet. The OLEDB. 4.0; The Data Source=mySpreadsheet. XLS; Extended Properties='Excel 8.0; HDR='";
Correction: "the Provider=Microsoft. ACE. The OLEDB. 12.0; The Data Source=mySpreadsheet. XLS; Extended Properties='Excel 8.0; ';"
Patch KB4041678 or uninstall