export queries' text -- not their data -- to text file

C

charles.schwartz

I have lots of queries that I'd like to archive as text files. To be
clear, I want to export the text of the query, the code, the "stored
procedure", not the data that the code generates.

Since there are lots of these queries, I'd like to avoid opening each
one and copying and pasting out the SQL code.

Is any of this possible?

Thanks in advance.
 
K

KARL DEWEY

Go to TOOLS - Analyze - Documenter - Select the queries you want - under
Options select SQL. Click OK and then save as 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

New computer, how do i move outlook 365 ENTIRELY? 0
How to Change criteria on a saved query using VBA 0
"enter" at the end of a exported text file. 0
Automation of scanned file storage based on content 0
Export to text 2
Internal Data Integrity (Type 4) Details Needed 1
Export Access pivot table to Excel 0
exporting as text cutting off significant digits 2

Top