Hi Naomi.
This is not a VFP program..... its a c# app.
Regards,
Gerard


>>Hi Naomi. Tahanks for replying.
>>This is a C# program , should I not be using SQL syntax ?
>>How using C# and OleDB, can I select out into a Temporary table
>>
>>Regards,
>>Gerard
>>
>If you're using VFP, then try
>
>select * from MyTable into cursor csrTemp
>
>How do you intend to use this temp table?