Hi Naomi. Thnaks for replying
CommandText = @"SET EXCLUSIVE ON
USE myTable IN 0 EXCLUSIVE
ZAP in MyTable"

In the text above , the Use and the Zap appear in separate lines
Do you put any characters in to cause this to happen or just blank spaces ?
regards.
Gerard




>>Hi
>>In C# app, I want to Zap a VFP table using an OleDb Command Object
>>I've tried for the Command.Text:
>>" Set Exclu On ; Use MyTable ; delete All; Pack; Use"
>> and
>>" Set Exclu On \r\n Use MyTable \r\n delete All \r\n Pack \r\n; Use"
>>
>>but neither seem to work
>>
>>Any idease ,
>>Tia
>>Ger
>Have you tried
>

>CommandText = @"SET EXCLUSIVE ON
>                                USE myTable IN 0 EXCLUSIVE
>                               ZAP in MyTable";