hello,
thank you for reply,
I sent you a sample in your other thread.?? where



>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