You can use Automation to remove first row after creating XLS file.
COPY TO (lcXlsFile) XLS
oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Workbooks.Open(lcXlsFile)
oWorkbook.ActiveSheet.Range("a1:iv1").Delete()
oWorkbook.Save()
oExcel.Quit
>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
--sb--