Unload/Export/output data from a query?? (1 Viewer)

[killyridols]

Hi,
I want to "unload" my query results to a specified folder as a .dat file.
I have some old SQL scripts where the command seems to be:

UNLOAD to "C:\test.dat"

However UNLOAD is not a legitimate command in Access...

does anybody know an alternative?

thank you!

 

[akt01]

if you create a new macro, TransferDatabase is an option. You can specify the destination folder and export filetype, but i don't see ".dat" as an option

good luck.

 

[killyridols]

Hmmm... I don't want to output the whole database to file, I just want to output a query table to file... (I don't need it to be a dat 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"