COPY TO DELIMITED will create CSV file w/o a header. You can create header record separatelly and append the file to it.
>I have a customer that is wanting data exported to a CSV file. The COPY TO, takes care of this. However, they want the field names to be "long names" in other words, one of the field names is "confirmed shipping date"
>
>Is there a way to export this without having to massage the flat file after creation. FOPEN, etc...
>
>It would be nice if I could
>Create Cursor xport (confirmed shipping date c(10)) but of course that won't work.
>
>My files are probably too big to do a filetostr then search and replace then strtofile. Do you know the limits?
>
>Ideas?
--sb--