Steven said:
I need to export to a csv file but do not put quotes around the data.
Use the File - Export menu to manually export the
table/query to CSV type file. Use the Advanced button to
specify how to delimit the fields and save the
specifications.
You can then reload the saved Import/Export specs the next
time you want to export the same table/query. If you want
to do it using code (behind a button on a form?), you can
use the TransferText method (see VBA Help for details) with
the previously saved specs.