exporting CSV table

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.

You can use the standard export VBA code to export to a CSV file

Code:

---

DoCmd.TransferText transferType:=acExportDelim, TableName:="Query1", FileName:="C:\test\Query1.txt", hasfieldnames:=True

---