469,922 Members | 2,157 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,922 developers. It's quick & easy.

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 1135

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 this site, you agree to our Privacy Policy and Terms of Use.