exporting a list of queries in a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with over 100 queries in. Is there a way to export a list
of the names of the queries to Excel or a text file?
 
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Name Not Like "~*"
AND MSysObjects.Type=5
ORDER BY MSysObjects.Name;

The SQL above will get you the list of query names. It excludes queries
starting with ~ as these are used as record sources for forms and reports
which means that they don't show up in the Queries on the database window
Objects Bar.

Once you run the query, you can use Office Links to put it in Word or Excel.
 
Back
Top