Importing data form diferent tables and database types

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

Article #2959

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

#2959

From: In�s Fern�ndez
Date: Fri, 14 Feb 2003 13:52

17 lines
1587 bytes

Hi all!
I am working in a program that must import data from a DBase table to
another table in an SQL server database. The second table has two more
fields than the first one, but the rest of the fields are the same.
For example:
If I have a record in the DBase table as follows:
{10, 20, 15, 33, 6} (it has 5 integer fields with this values)
I must save in the SQL server table something like this:
{anything,anything, 10, 20, 15, 33, 6}

Is there an easy way to do this?
Is there a component or structure or something where I can get the data from
the DBase table, manipulate it and save it to the SQL server table?
Any ideas?

Thanks in advance:
Ines Fernandez

Technical Details

Message-ID: <3e4cf489$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,5718363b56ae1b18,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-02-14 05:58:23 PST
From: "In�s Fern�ndez" <ifernandezmed@terra.es>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Importing data form diferent tables and database types
Date: Fri, 14 Feb 2003 14:52:14 +0100
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 80.59.94.142
Message-ID: <3e4cf489$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1045230729 80.59.94.142 (14 Feb 2003 05:52:09 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail