copy certain data from one database to another

Hi All,

  I have another challenge need to ask:

I want to copy (or EXP/IMP) 50 rows of data from one table of 1000 rows from one database to another DATABASE same table structure but already contain data 500 rows.

I don't know if it can be done. If it can what happen if some of the rows is duplicates?

Thanks in advance

DAVID Received on Sat Feb 22 2003 - 23:56:09 CST