I have a production database (Access) running on a web server, and a duplicate "staging" database which is to be used for table import/export from/to the production database. For example, I make changes to some tables in my local copy of the database, then FTP it to the web server to become the "staging" database. I now need to be able to import the tables from the staging database to the production database using ADO (VBScript). For some tables, the import would be a full replacement, but for others it would be an update/append action. Is there a simple way to do this, given the source and destination tables will have separate connections?
I hope someone can point me in the right direction here. Sample code would be appreciated. Thanks in anticipation.