Example of a data pump.

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

Article #1455

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

#1455

From: Peter Nunn
Date: Wed, 16 Jun 2004 04:46

16 lines
1423 bytes

Guys,

I need to implement a datapump application that takes data from an
Excel spreadsheet and either inserts it into a DB if its not there or
update the current record if it is there (based on the key field).

Now, I've managed to open connections to both tables OK but I'm not
sure what the best way to implement the pump is.

Should I just open the query on the spreadsheet and work through it
one at a time and checking the fields and updating the insert or
update query myself or is there a better way to do this?

Thanks for the help.

Peter.

Technical Details

Message-ID: <d1kvc055k70ks7fr707v1hn7bdr2iouop7@4ax.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.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,2e60b65b71363740,start
X-Google-Attributes: gid10698b,public
From: Peter Nunn <pnunn@infoteq.com.au>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Example of a data pump.
Date: Wed, 16 Jun 2004 14:46:38 +1000
Organization: Infoteq P/L
Reply-To: pnunn@Infoteq.com.au
Message-ID: <d1kvc055k70ks7fr707v1hn7bdr2iouop7@4ax.com>
X-Newsreader: Forte Agent 2.0/32.646
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 203.113.216.18
X-Trace: newsgroups.borland.com 1087362289 203.113.216.18 (15 Jun 2004 22:04:49 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail