Export query results to flat file

[JC]

I'm looking for a simple solution to export query results
of two colums, 4 records to a comma delimeted flat file
showing 8 lines.

 

[Michel Walsh]

Hi,


Make a UNION query, export it.

SELECT f1 FROM myTable
UNION ALL
SELECT f2 FROM myTable


from myTable a table (query) with two columns, f1 and f2


Hoping it may help,
Vanderghast, Access MVP