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