VFP6/SP3

I am trying to iterate over a table in one DBC and insert those records into a table in a second DBC. The code looks like this (which doesn't work, can you help me ill in the holes):

set datasession to 1
use dbc1!table1 in 0
use dbc2!table1 in 0
set database to dbc1
select dbc1!table1
scan
scatter memvar
insert into dbc2!table1 from memvar
endscan

Help!

Thanks.