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


>>I have an Oledb link set up to a VFP table with a command like:
>>Select * from MyTable into #MyTemp1
>> but keep getting a syntx error when I run any command option (i.e. comm.EcecuteReader, comm.ExceuteScalar, comm.ExecuteNonQuery.
>>
>>If I take out the Into #MyTemp1 , workds fine.
>>
>>Tia
>>Gerard
>
>The syntax you're trying to use is SQL Server syntax, not VFP, so no wonder you're getting an error.