>I want to give my users the option of exporting data to various file formats and have a text merge routine from my fox2.6 days which creates a CSV file with a header row with the column names in it.
>
>I've investigated the Copy To command but it doesn't seem to let me specify that the header row gets output. Have I missed something? Is there another command? or do I keep using my old routine?
>
>Sarah

The "COPY TO" command now has a type CSV option. It's mispelled in the VFP help as CVS.

Command syntax example is:

USE TF
COPY TO TF.TXT TYPE CSV

The output from this includes the field names in the first row.

Of course, you also have your old routine from FoxPro 2.6 for CSV.

FYI, I put out a routine here in this forum on 17 August, 2000 for tab-separated values that includes a header row with the column names. This routine could be copied and adapted as needed.

Forum: Visual FoxPro Category: Coding, syntax & commands Title: Re: Tab Separated Values Thread #406399 Message #406459