Hi!
I'm trying to get infos in a table of the current opened database and copy it to a new table in another database, but I always get the error 3067 in vb5, following is a piece of code I use.

set dbfas=opendatabase("c:\fas.mdb")
sSql="select * into [fas_temp] in c:\temp.mdb from [fas_hld] where agent_id='96202222';"

dbfas.execute sSql

Am I doing something wrong?

Thanks for your replies.