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??
Click to expand...


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
Click to expand...


__________ 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