>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
Regards,
Peter J. Kane
Pete