Import/export tables from one database to another?

ASP Free Forums Sponsor:

September 16th, 2004, 08:19 PM

splinters

Bug Catching Moderator

Join Date: Sep 2004

Location: Australia

Posts: 3,552

Folding Points: 7190 Folding Title: Novice Folder

Time spent in forums: 1 Month 1 Day 11 h 4 m 52 sec
Reputation Power: 86

Import/export tables from one database to another?

Help Please !!

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? The solution needs to work for any table, so be independent of the table structure. I'm guessing recordset cloning isn't an option, since the clone inherits the connection properties of its parent.

I hope someone can point me in the right direction here. Thanks in anticipation.

September 17th, 2005, 04:12 PM

Shadow Wizard

Moderator From Beyond

ASP Free God 45th Plane (27000 - 27499 posts)

Join Date: Sep 2004

Location: Israel

Posts: 27,266

Folding Points: 356912 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 3 Months 1 Week 6 Days 12 h 6 m 3 sec
Reputation Power: 1791

exactly one year ago..... amazing how things has turned out!!

so, Mr. Wizard, you got it solved at some point?

congrats for the one full year of membership!!!

__________________

Visit The Windows Scripting Guru

September 17th, 2005, 04:14 PM

RadioactiveFrog

Senior Glowing Wizard

ASP Free God 7th Plane (8000 - 8499 posts)

Join Date: May 2005

Location: Sussex

Posts: 8,203

Folding Points: 158091 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 3 Weeks 4 Days 39 m 12 sec
Reputation Power: 291

Send a message via MSN to RadioactiveFrog

Quote:

Originally Posted by Shadow Wizard

exactly one year ago..... amazing how things has turned out!!

so, Mr. Wizard, you got it solved at some point?

congrats for the one full year of membership!!!

so do you dig out everyones first post after a year then???

__________________

September 17th, 2005, 05:22 PM

splinters

Bug Catching Moderator

Join Date: Sep 2004

Location: Australia

Posts: 3,552

Time spent in forums: 1 Month 1 Day 11 h 4 m 52 sec
Reputation Power: 86

Quote:

Originally Posted by Shadow Wizard

exactly one year ago..... amazing how things has turned out!!

so, Mr. Wizard, you got it solved at some point?

congrats for the one full year of membership!!!

Thank you Shadow

My, how time flies!!
Yes, I eventually solved my problem. I think the fact that nobody replied to my question a year ago actually got me started helping others, since I knew what it felt like to be "left out in the cold"

Comments on this post

RadioactiveFrog agrees: Congrats on winning the avatar contest!!

__________________
Have I made your day? If so, please show your appreciation either by sending money

or the cheaper, preferred option of clicking on the scales icon at the top right of this posting. My reputation needs all the help it can get.

September 18th, 2005, 03:18 AM

Shadow Wizard

Moderator From Beyond

Join Date: Sep 2004

Location: Israel

Posts: 27,266

Time spent in forums: 3 Months 1 Week 6 Days 12 h 6 m 3 sec
Reputation Power: 1791

Quote:

Originally Posted by RadioactiveFrog

so do you dig out everyones first post after a year then???

nope, sometimes I do that before one year pass.....

Quote:

Originally Posted by splinters

Thank you Shadow

does it mean we should not always reply so that we get more members to join us and become active?

September 18th, 2005, 04:52 AM

micky

Couch Potato Wizard

Join Date: Jan 2005

Location: India

Posts: 10,803

Folding Points: 1480 Folding Title: Novice Folder

Time spent in forums: 4 Months 3 Days 22 h 22 m 19 sec
Reputation Power: 1694

congrats splinters for 1st anniversary of joining this forum

Shadow has ur 1 year done or left with some days??

__________________
Laziness is my religion and Sunday is my God

Get the Mantra!

September 18th, 2005, 04:53 AM

micky

Couch Potato Wizard

Join Date: Jan 2005

Location: India

Posts: 10,803

Time spent in forums: 4 Months 3 Days 22 h 22 m 19 sec
Reputation Power: 1694

ok shadow i checked it and its on 24th of this month........ so u'll have 14 rep power then........... amazing

September 18th, 2005, 05:03 AM

Shadow Wizard

Moderator From Beyond

Join Date: Sep 2004

Location: Israel

Posts: 27,266

Time spent in forums: 3 Months 1 Week 6 Days 12 h 6 m 3 sec
Reputation Power: 1791

Quote:

Originally Posted by micky

ok shadow i checked it and its on 24th of this month........ so u'll have 14 rep power then........... amazing

with any luck (and some 21 more RP) it would be 15...

the amazing thing in my story is, that whoever it was who brought me here (can't even remember who it is) is now gone.

September 18th, 2005, 05:12 AM

micky

Couch Potato Wizard

Join Date: Jan 2005

Location: India

Posts: 10,803

Time spent in forums: 4 Months 3 Days 22 h 22 m 19 sec
Reputation Power: 1694

well if u cant remember who it was, then how can u say that he is gone??

and u'll have 15 in no time!!

#10

September 18th, 2005, 07:48 AM

Shadow Wizard

Moderator From Beyond

Join Date: Sep 2004

Location: Israel

Posts: 27,266

Time spent in forums: 3 Months 1 Week 6 Days 12 h 6 m 3 sec
Reputation Power: 1791

Quote:

Originally Posted by micky

well if u cant remember who it was, then how can u say that he is gone??

and u'll have 15 in no time!!

if he would have posted I could remember him...