title: Parse SELECT query
body: <p>I would like to find out table names involved in a Select query with the help of VBA. For example I have to find out the tables involved in the below query in <strong>slottime and time</strong>.  </p>
  
  <pre><code>SELECT MAX(theCount) FROM
      (SELECT FK_Hour, Count(FK_Hour) As theCount FROM 
          (Select FK_Hour 
          From slottime 
          INNER JOIN time ON slottime.FK_Hour = time.Hour 
          WHERE FK_Hour in
              (SELECT time.Hour FROM time WHERE time.day=0 )
          ) As C 
          GROUP By FK_Hour
      ) AS counts;  
  </code></pre>
  
  <p>Will it be possible with VBA? </p>