VBScript:Update One Access DB from Another

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.

Not quite sure what you mean. Do you mean using VBA in Access, ASP in web pages or Windows Scripting Host?

Nick

I would expect the product I am using would be closest to Windows Scripting. I am using eMill from ActivePlus software. This product creates an Access database for each project.

Within their software, which uses VBScript, I want to read each Access database, grab data and dump it into a new access database that provides a history of all activity for each project.

You probably will be using ADO from within VB, VBScript, or any other COM-capable programming environment you choose to use.

http://msdn.microsoft.com/library/e.../mdaprogref.asp

VBScript ADO Programming help:
http://msdn.microsoft.com/library/d...ogramming_3.asp