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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only