ADO:ACCESS and copy tables... ?

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

Article #3835

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

#3835

From: Peter
Date: Wed, 05 Jun 2002 09:19

19 lines
1431 bytes

Hi,

I want to copy one table from ACCESS database X in Tokio :o)  to
another ACCESS database Y in Melburne ... or better the contents of table.
The structures of tables in X and Y are the same.

How can I do that ?

With dataset->SaveToFile(...) I can save the dataset (the content of table)
and after send it from Tokio to Melburne with dataset->LoadFromFile(...) I
can load
the contents, but it is not in the database Y.

I've try it with dataset->UpdateBatch(arAll), but it doesn't work...

(C++ Builder 5 pro ADO Express)

thanks,
peter

Technical Details

Message-ID: <3cfdd7f1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,6741102e70bcafbc,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-05 02:28:51 PST
From: "Peter" <p.krenz@web.de>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO:ACCESS and copy tables... ?
Date: Wed, 5 Jun 2002 11:19:23 +0200
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 217.88.59.190
Message-ID: <3cfdd7f1_1@dnews>
X-Trace: dnews 1023268849 217.88.59.190 (5 Jun 2002 02:20:49 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews