You might do the following:
1) Copy to..., as you outlined.
2) Open the file in Excel, delete the first row, and save it again.
Provided you have Excel properly installed, the second step can be controlled from VFP.
HTH,
Hilmar.
>I am converting a .dbf file to an Excel File by using the command below:
>
>COPY FIELDS FIELD1, FIELD2 .......... TO C:\TEMP\FILE1 TYPE XLS
>
>This command creates an Excel file but the first row of the Excel file has the field names from the .dbf file.
>
>I would like to create the Excel file without that first row.
>
>I have tried adding the parameter OFF to the command and that doesn't work.
>
>If anyone has a solution for this. I would be pleased to hear from you.
>
>Mike Smith
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
