472,119 Members | 2,144 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

import tables from one database to another with asp

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.
Jan 17 '07 #1
0 1172

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Jon Ole Hedne | last post: by
5 posts views Thread by strauss.sean | last post: by
7 posts views Thread by Randy | last post: by
2 posts views Thread by Mark S | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.