Yes you can use
INSERT INTO target [IN externaldatabase] [(field1[, field2[, ...]])]
SELECT [source.]field1[, field2[, ...]
FROM tableexpression
but I am sure that it will raise an error if the primary key is the same (haven't tried it thought)
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'