title: Reading excel with the driver xlsx vb6
body: <p>I'm having a problem during one week, and I couldn't find the solution. I'm trying to read a file in xlsx on vb6 as a component of the asp classic.</p>
  
  <p>First issue that I couldn't be able to solve was this</p>
  
  <pre><code>Dim cn As New ADODB.Connection
  Dim provider As String
  provider = "Driver={Microsoft Excel Driver (*.xlsx)};DBQ=" &amp; nomArq &amp; ";"
  Set cn = CreateObject("ADODB.Connection")
  cn.Open provider
  </code></pre>
  
  <p>The error that I got in this connection was </p>
  
  <blockquote>
    <p>"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"</p>
  </blockquote>
  
  <p>The second try was in this way</p>
  
  <pre><code>Dim cn As New ADODB.Connection
  'Dim provider As String
  With cn
      .provider = "Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; nomArq &amp; ";" &amp; ";Extended Properties=\""Excel 8.0;HDR=Yes\;"""
      .Open
  End With
  </code></pre>
  
  <p>And the erros was </p>
  
  <blockquote>
    <p>"Format of the initialization string does not conform to the OLE DB specification."</p>
  </blockquote>
  
  <p>I also tried in another way and I got the error: </p>
  
  <blockquote>
    <p>"could not find installable isam"</p>
  </blockquote>
  
  <p>but I don't have the code hear anymore.</p>
  
  <p>someone could help me, I looked in all most everything on google</p>