>>>Does anyone know if the COPY TO TYPE XLS still puts the field names as the first row of the spreadsheet in VFP7?
>
>>If you don't want the field names than you can use
COPY TO Myfile.csv DELIMITED
The Excel knows how to open CSV files.
>
>And if you give the target file the extension XLS, you can even open it in Excel, so that's *almost* cool. Unfortunately there's all those quotes and it stuffs all the data in the first column of cells.
In VFP 7 the following command creates a comma delimited file w/o double quotes
COPY TO Myfile.csv DELIMITED WITH "" with CHARACTER ,
--sb--