Re: Oracle & Access

From: <ebaechle_at_hospvd.ch>
Date: Wed, 29 Sep 1999 15:35:24 +0100
Message-ID: <37F223AC.92FBE2D@hospvd.ch>

> I have an access table with about 1500 records in the table.
> I want to take these records and update matching records in
> an Oracle table.
>
> I'm not quite sure how to do this. I do not want to have to
> dump it to a file and write some lame procedure. Is there a
> way for Access to talk to Oracle and perform the updates?

A solution is to attach the Oracle table into the Access Database through ODBC. Then, it is possible to write an update query that will update the content of the ORACLE table from the content of the local one. You may also create a form whch will both update existing records and insert the new ones.

Emmanuel Baechler
Lausanne
Switzerland Received on Wed Sep 29 1999 - 09:35:24 CDT