Exporting Access Queries to a File

[crebel]

I am trying at export an Access query to the following file types (.dqy, oqy. iqy. rqy). I want the actual query and not the data, so I can save them as the listed above file types. Thanks for any help.

creedford
creedford@hotmail.com

 

[pdx_man]

Under View select SQL to get the actual text that is behind the GUI. Copy that out to a text editor and save them with whatever extensions you wish. (Are those you listed text formatted files or some other proprietary format?)

 

[crebel]

Those file extensions are different types of saved queries. (not .iqy, that is a Microsoft Web Query) I like your idea, but I tried it and it didnt work. Do you know how to create a query file (.dqy), or maybe what program to use? Thanks again.

 

[pdx_man]

Sorry, I don't. I'll ask around, though.

 

[Pat Hartman]

Are the file types you mentioned just simple text files with other extensions? Find out by trying to open them using notepad. If notepad opens the file and all you can see is an SQL statement, then the file format is simple text. In which case, you can obtain the text of the querydef by looking at one of the properties (text ?) of the querydef collection.