I need to view multiple queries' SQL statements

  • Thread starter Thread starter SQL novice
  • Start date Start date
S

SQL novice

I have a massive amount of queries that I need to view the SQL statements
for. Instead opening each one separately, I'd like to download each query and
just its SQL statements onto one view (spreadsheet, word doc, etc).....
 
Click on menu TOOLS - Analyze - Documenter.
Click on the Queries tab. Click on Options. Select SQL and nothing else.
Click OK.
Click OK. On the icon bar click on Office Links icone (Has a small blue 'W'
in a square) and select Publish to Word.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I execute multiple SQL statements in Access?? 3
Using Design View versus SQL Statement View 11
SQL query 1
Calling Parameterized Query Using SQL Syntax 3
Modifying subform's underlying SQL statement 2
Combine Duplicates in Query 0
Query <3 years 1
access 2007 criteria in query 2

Back
Top