title: Jet OLEDB Provider working everywhere except Excel 2010 on Windows 7 64-bit
body: <p>I'm using the "Microsoft.Jet.OLEDB.4.0" provider for a basic connection in some VBA code, and the code works everywhere except on windows 7 64-bit operating systems running a 64-bit installation of Microsoft Office Excel 2010.</p>
  
  <p>Literally every other combination of XP 32 or 64, Vista 32 or 64, and 7 32, with Excel 2003, 2007, or 2010 installations has no problem running this code, but on the above described system, it results in an error about a "Missing Provider" and I can't create the connection string.</p>
  
  <pre><code>With Conn
      .Provider = "Microsoft.Jet.OLEDB.4.0"
      .Mode = adModeRead
      .ConnectionString = "Data Source=" &amp; path &amp; ";Extended Properties='text;HDR=YES;FMT=Delimited'"
      .Open
  End With
  </code></pre>
  
  <p>I've done a ton of research, but from what I can tell, the operating system is supposed to come with a full set of providers, including the 32-bit version of the Jet Provider (no 64 bit version exists), and Excel should have no problem using it for the connection. Any ideas? </p>