lonemarino
Computer
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.
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.
