title: Using VBA-Excel for an SQL query across multiple databases
body: <p>Using Excel 2010, SQL and DAO</p>
  
  <p>I am trying to execute a query against tables which reside outside the current spreadsheet.   This would be trivial, inside Access, with linked tables/databases, but using VBA in excel, I am stymied.</p>
  
  <p>Presuming these:</p>
  
  <pre><code>ExcelFileOne; Tab; various headed field/columns
  ExcelFileTwo; Tab; various headed field/columns
  </code></pre>
  
  <p>I want to execute a query inside a third excel file, that goes something like this [using dot notation for explanation, not coding....] -- a simple example:</p>
  
  <pre><code>SELECT FileOne.[Tab$].Fields, FileTwo.[Tab$].Fields, etc.
      FROM FileOne, FileTwo, Thisworkbook
      WHERE (FileOne.[Tab$].field2 &lt;&gt; FileTwo.[Tab$].Field2) 
          AND (ThisWorkbook.[Tab$].Field1 ....)
  </code></pre>
  
  <p>Basically, I want to duplicate what Access will do natively, for that linked file.</p>
  
  <p>Pointers in the right directions ?</p>
  
  <p>[[ I could use a pointer towards why using "Excel 8.0..." in a connection works or fails on Excel2010, with macro files, and how to load the 12 or 14 variant in a network/system closed to users.... ]]</p>