Also, the syntax to create an Excel file is wrong. You should use COPY TO (myExcelFile) TYPE XL5 and then you can give specific Sheet name through Automation. I sent you a sample in your other thread.
>hi all,
>
>i have at the table 38 records i need to select 2 records evrey time and convert it to excel book
>
>as
>
>select, scan or for * from mytable first 2records
>copy to book1.sheet1 name is (q1)
>
>next 2 records
>
>copy to book1.sheet2 name is (q2)
>.
>.
>.
>
>end of file
>
>
>thanks
If it's not broken, fix it until it is.
My Blog