Update One Access DB from Another

[lonemarino]

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.

 

[FrancisL]

You can have a query that appends records from one database into another - look up the INTO SQL keyword.