Would an append query do the job? You could find out how to create an append query in the microsoft office help. From what I understand, such a query copies records from one table to another, within the same database or in another database. If there are duplicate records in the 'destination' table, then Access will tell you how many are duplicates and you won't be able to send those over.