exporting CSV table

[DBinPhilly]

A customer needs to create and export a csv table. I haven't done this in many years. Since my client is essentially a Neanderthal, I can't expect him to do a series of steps. I want to programatically grab the data, export it to a saved location, and name it properly, with little or no operator intervention.

The data itself is quite simple. I'd welcome any suggestions of how to do this.

[OBP]

You can use the standard export VBA code to export to a CSV file
DoCmd.TransferText transferType:=acExportDelim, TableName:="Query1", FileName:="C:\test\Query1.txt", hasfieldnames:=True