Colin,
You can't do this with COPY TO. You could use low-level file functions (FCREATE(), FPUTS(), FLCOSE()) to create the file. Be aware that if there are commas in any of your data (e.g., "John Smith, Jr.") you'll run into problems without having the quotes around the character data.
>Does anyone know how to export a FoxPro table to a comma delimited text file? In other words, I want every field value delimited by a comma with no quotes around character values. TIA