copy tables between databases in access 2000

Article View: borland.public.cppbuilder.database.ado

Article #1568

Back to borland.public.cppbuilder.database.ado Previous Next

#1568

From: siraj
Date: Tue, 18 May 2004 17:53

16 lines
1653 bytes

Hi!
 I use ADO components to connect to MS Access 2000 . I am using c++ builder
5.
Periodically I have to create new databases  and copy some tables along with
the data  from the old
database to the new database.  The old database and the new database are
identical in structure. I create new access 2000 database using the
components derived from importing the type library "Microsoft ADO Ext. 2.6
for DDL and Security".
How can i copy the tables from one access 2000 database to another access
2000 database?
I have to even copy the relationships between the tables and their data and
overwrite the empty tables in the new database.

Regards,
siraj

Technical Details

Message-ID: <40aa4d8e@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!atl-c02.usenetserver.com!c03.atl99!news.usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ada5c065ec93594c,start
X-Google-Attributes: gid10698b,public
Reply-To: "siraj" <siraj.sm@omnisens.ch>
From: "siraj" <siraj.sm@omnisens.ch>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: copy tables between databases in access 2000
Date: Tue, 18 May 2004 19:53:18 +0200
Lines: 18
Organization: omnisens
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 128.179.67.34
Message-ID: <40aa4d8e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1084902798 128.179.67.34 (18 May 2004 10:53:18 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!atl-c02.usenetserver.com!c03.atl99!news.usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail