Hi, I have two separtate databases and I need to append one table from one database to another table in the other database. There will be some records already in the target table that are also in the table that I need to add. What is the best way to do this without adding duplicate records? Thanks

Import your table from dbase A into dbase B. In dbase B create a UNMATCHED query to find the records that are NOT in dbase A. Then change the query to an APPEND QUERY and append them to your table in dbase B.

HTH

PS. If you are going to do this on a regular basis, consider linking your tables.