title: How to resolve the ADODB connection string to updated window and excel?
body: <p>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.</p>
  <p><strong>Connection String:</strong> <em>Provider=Microsoft.Jet.OLEDB.4.0;&quot; &amp; &quot;Data Source= &quot; &amp; Application.ActiveWorkbook.FullName &amp; &quot;; &quot; &amp; &quot;Extended Properties=&quot;&quot;Excel 8.0;HDR=Yes;IMEX=1&quot;&quot;;</em></p>
  <p><strong>Error Message:</strong> <em>Error GetContact – 3706 – ADODB.Connection – Provider cannot be found. It may not be properly installed.</em></p>
  <p>I am not sure whether window 10 is the issue or the excel version.</p>