>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.