I need to write a procedure that inserts data from one Access database into another Access database through VBScript.  I imagine that this would be done with Recordsets.  Can anyone post an example of how to do this for me?

Basically I would want to:

1. select name, date, status from table in 1st database
2. insert that result set into a history table in another database, checking to be sure that it won't create duplicate rows.

The databases have to remain separated since the first database is created by a proprietary application.

Thanks in advance for all replies.