Export query results to flat file

  • Thread starter Thread starter JC
  • Start date Start date
J

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.
 
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
 
Back
Top