Hi Borislav,
It's general bug for ODBC driver "Microsoft Excel Driver (*.xls)" and OLEDB driver "Microsoft.Jet.OLEDB.4.0" after last security updates.
Use ODBC driver "Microsoft Excel driver (*.xls, *.xlsx, *.xlsm, *.xlsb)"
MartinaJ
>After October update of Windows 10 I started to get this error when I try to import Excel file:
>
>
>[Microsoft][ODBC Excel Driver] Reserved error (-5016); there is no message for this error..
>
>These are my favorite kinds of errors - I get error but NO explanation at all.
>
>This is the connection string I use:
>
>DRIVER=Microsoft Excel Driver (*.xls);
>DriverId=790;
>DefaultDir=...;
>DBQ=...;
>Extended Properties="Excel 8.0;HDR=NO;IMEX=1;";
>
>
>I don't have any problems with Windows 7 (till now, but nobody knows).
>
>So, does anybody knows how to get over this?
>
>TIA
>Boris