Re: Duplicating a Table wth ADO

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

Article #2026

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

#2026

From: Palmetzhofer Dietmar
Date: Fri, 12 Dec 2003 09:02

28 lines
1942 bytes

Should it be DB-independent?
If using Access, you could use the "Insert into" statement.
e.g.
SELECT Table1.* INTO test1 IN 'E:\testmdb.mdb'
FROM Table1;
Greetings,
Didi
"Daniel Stevenson" <d.stevenson@ocreage.com.au> schrieb im Newsbeitrag
news:3fd7ec3d$1@newsgroups.borland.com...
> I'm trying to work out the best method for duplicating a table within one
> database to another database so that all the fields are the same, the
> indexes are the same, etc.
>
> I have been using SQL CREATE TABLE but I can't seem to determine the
indexes
> from the existing ADOTable in order to complete the SQL call properly.
>
> I have heard about using the OpenSchema but can't seem to find the
> information I'm after (or I can't interpret what I have been seeing).
>
> I am currently using an Access Database but I will also need to use the
> function within other databases (eg MySQL).
>
> Can anyone help?
>
> Much appreciated.
>
>

Technical Details

Message-ID: <3fd98287@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3fd7ec3d$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,e62fa7bff80f5ea8
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-12-12 01:09:08 PST
Reply-To: "Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at>
From: "Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3fd7ec3d$1@newsgroups.borland.com>
Subject: Re: Duplicating a Table wth ADO
Date: Fri, 12 Dec 2003 10:02:01 +0100
Lines: 30
Organization: Univ. f. Bodenkultur
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 62.46.232.107
Message-ID: <3fd98287@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1071219335 62.46.232.107 (12 Dec 2003 00:55:35 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message