How to export queries in Access 2007 to text files

[wikky]

I have a ton of queries for a database in Access 2007 and I need to export all of them to text files. I have searched everywhere and haven't found a solution intuitive enough.



I tried going to the 'External Data' tab and then choosing 'Text File', but it tries to output the result set and not the actual query itself. HELP!

[RuralGuy]

Have you looked at the undocumented "SaveAsText" function? It sounds like you want the SQL view saved as a Text file.

[Access_Blaster]

Have you tried to right click on the query? You can right click on your query and export it to the desktop as a pdf or TXT.

[wikky]

I haven't tried the SaveAsText function and I can'tright-click and save the file as PDF or text because I do not want the query results. I would like the queries themselves. Preferably to exported to SQL files if possible since these will be imported into a SQL Server database. Thanks

[RuralGuy]

In either a Standard module or the immediate window:
Application.SaveAsText(ObjectType AS acObjectType, ObjectName As String, FileName As String)

LoadFromText is identical in its parameters. For example:

Application.SaveAsText(acForm,"frmMyForm","H:\Clie ntX\frmMyForm.txt")

[wikky]

RuralGuy--I am sort of a noob to advanced features in Access. If you could elaborate/break down the steps to accomplish that, then I would greatly appreciate it. Thank you

[RuralGuy]

I just tested it on a query and it will not do what it sounds like you need anyway. I'll keep looking for a solution.