title: Upload An Excel File in Classic ASP On Windows 2003 x64 Using Office 2010 Drivers
body: <p>So, we are migrating an old web app from a 32-bit server to a newer 64-bit server. The app is basically a Classic ASP app. The pool is set to run in 64-bit and cannot be set to 32-bit due to other components. However, this breaks the old usage of Jet drivers and subsequent parsing of Excel files. </p>
  
  <p>After some research, I downloaded the 64-bit version of the new <a href="http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&amp;displaylang=en#filelist" rel="nofollow noreferrer">2010 Office System Driver Beta</a> and installed it. Presumably, this allows one to open and read Excel and CSV files.</p>
  
  <p>Here's the snippet of code that errors out. Think I followed the lean guidelines on the download page:</p>
  
  <pre><code>Set con = Server.CreateObject("ADODB.Connection")
  con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.14.0;Data Source=" &amp; strPath &amp; ";Extended Properties=""Excel 14.0;"""
  con.Open
  </code></pre>
  
  <p>Any ideas why?</p>
  
  <p>UPDATE: My apologies. I did forget the important part, the error message:</p>
  
  <blockquote>
    <p>ADODB.Connection error '800a0e7a'<br>
    Provider cannot be found. It may not<br>
    be properly installed.<br> 
    /vendor/importZipList2.asp, line 56</p>
  </blockquote>
  
  <p>I have installed, and uninstalled/reinstalled twice.</p>