I need to view multiple queries' SQL statements

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).....
 
K

KARL DEWEY

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

view multiple Queries' SQL statement 3
Editing queries in SQL view 2
How do I execute multiple SQL statements in Access?? 3
Create multiple queries in Access with a single sql statement 15
Queries: putting multiple cells of queried data on only one line 5
Format SQL Queries 3
copying SQL statements to Excel 9
Nested SQL Statements causing slowness and errors 7

Top