Appending data from one database to another!

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Appending data from one database to another!

Logged in as: Guest

arrSession:exec spGetSession 2,2,1037

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Appending data from one database to another!
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Appending data from one database to another! - 5/28/2004 7:16:00 AM

JoaTMoN

Posts: 1
Score: 0
Joined: 5/28/2004
From: USA
Status: offline

I am working on a project using VBScript that is accessing 2 Access db's. My problem is that I am not sure how to append the data from one database to the other. In Access, a querry statement like the following works:

INSERT INTO tblProjects IN 'FILELOCATION\DATABASENAME.mdb'
SELECT TABLENAME.*
FROM TABLENAME;

Can someone help point me in the right direction to to convert that sql statement using ADO. Thanks for any input.

Hey, Programmers can do anything...as long as they have the right resources!