exporting as delimited CSV format (1 Viewer)

Is there any code that can output a query as CSV (delimited) where varibles are seperated by comma's and words are in "quotes"
this code i got here outputs the file but the output file is in the format "fixed width" but i need it in delimited format..

>DoCmd.OutputTo acOutputReport, "rptAllDiv2", >acFormatTXT, "D:\Temp\rAllDiv2.CSV", False


because i can do it in that format through
file -> save as/export ->
and do it that way, but is there some code to add to what is above to get it to do it? i believe you can add to the end of ur code a file which contains the way it should be laid out but i cant find where that would be located on my system

thanx for any help you can provide.

Darren Goulston

No code necessary , just use the TransferText Method/Action. Look them up in help. The Action entry has more detail but they both work the same way.

thanx

thank you, that works perfect..

funny thought cause i looked all through the macro fields and diddnt see it

o well

thanx a lot