how to get access query output to a text file

  • Thread starter Thread starter sudesh
  • Start date Start date
S

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??
 
sudesh said:
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.
 
sudesh said:
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
 
Back
Top