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