Solution to JET engine exception when connecting to excel after October patch update on win2008/2012 systems

Change the connection configuration in the program

Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=call file path

to

Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=call file path

or

Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=YES;IMEX=1';Data Source=call file path

Or replace it with the windows2003 system, but Microsoft stopped updating win2003 long ago, which poses security risks. If it is not necessary, it is recommended to resolve the issue by changing the code. Currently there is no other solution.