Compatible connection String for window 10/ excel 2016

I was using the below line for connection in my VBA application in window 8 and excel 2013 but when I tried to use my application from window 10 and Excel 2016, it fails to start with an Error.

Connection String: Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source= " & Application.ActiveWorkbook.FullName & "; " & "Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";

**Error Message:**Error GetContact – 3706 – ADODB.Connection – Provider cannot be found. It may not be properly installed.”

1 answer

"Excel 8.0" indicates it is an old Excel 97 xls file in use.

Howevere your new system probably do not have the Jet Oledb provider installed.

Try use a newer oledb provider,