Access VBA (2003 & 2007) - Parse out the "FROM" portion of a specified query's SQL statement...
Posted on 2015-01-30
I want a procedure that when passed the name of a query is able to Parse out the "FROM" portion of the SQL and give me just a list of the names of the source Tables and/or Queries. This needs to work on all query types.
If there's an easier way to get a list of the source objects without the need of Parsing out the "FROM" portion, I'm all ears.