How to "Export" query table in Access? (1 Viewer)

[killyridols]

Hello,
I want to export my query results table to a specified folder as a .dat file.
I don't want to output the whole database to file, I just want to output a query table to file...

Using Informix SQL the equivalent would be:
UNLOAD to "C:\test.dat"

and
Using Oracle SQL (I think?) the equivalent is:
INTO OUTFILE "C:\test.dat"

does anybody know an equivalent command that is used in Access?

Thank you!

 

[KenHigg]

You may be able to use the 'OutputTo' method. - ?

Link