Copying a table from one connection to another

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

Article #2872

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

#2872

From: Jonny
Date: Thu, 13 Mar 2003 17:30

18 lines
1449 bytes

Hi, I need to copy some data from one ADO connection table to another.

In access I could wite an SQL statement like this:

SELECT * INTO CurrentWOwithLabelPN IN 'c:\labels.mdb' FROM
CurrentWOwithLabelPN;

But If i try this on an ADO connection it just hangs

I've also tried using the Clone on a dataset, but this doesn't seem to work
correctly either.  Also i have tried setting a tables recordset to another
one, but this seems to mess up too

Any help would be GREATLY appreciated

Thanks

Jonny

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,cd9b32aa65d82f25,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-03-13 09:40:10 PST
From: "Jonny" <jonny@nospam.jonnywilk.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Copying a table from one connection to another
Date: Thu, 13 Mar 2003 17:30:31 -0000
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.49.107.158
Message-ID: <3e70c170@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1047576944 62.49.107.158 (13 Mar 2003 09:35:44 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!iad-peer.news.verio.net!news.verio.net!fu-berlin.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail