Hi Pete . Thanks for replying.

tried :
Select * into #MyTable from sometable
but still coming up with OleDbException...Syntax Error when it runs.

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
>>
>>
>>>>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.
>
>
>Gerard, in SS the syntax is: Select * into #MyTable from sometable