how to get access query output to a text file

[sudesh]

i am running multiple queries( sql ) on a table in access , i need the
outputs of all these queries consolidated into single text file without
affecting the previous results.
is there any way to do this??

 

[Paul Shapiro]

i am running multiple queries( sql ) on a table in access , i need the
outputs of all these queries consolidated into single text file without
affecting the previous results.
is there any way to do this??

If your queries are union-compatible (same output columns) then you could
use a single union query combining all the individual query outputs into one
query. If not, you could output each query to a text file and then use file
management commands to combine the files, although I don't see how that's
useful if the queries have different outputs. If you include the sql
statements, someone could be more helpful.

 

[ole]

i am running multiple queries( sql ) on a table in access , i need the
outputs of all these queries consolidated into single text file without
affecting the previous results.
is there any way to do this??

__________ Informaci�n de ESET NOD32 Antivirus, versi�n de la base de
firmas de virus 4441 (20090919) __________

ESET NOD32 Antivirus ha comprobado este mensaje.

http://www.eset.com

__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 4441 (20090919) __________

ESET NOD32 Antivirus ha comprobado este mensaje.

http://www.eset.com