Re: Oracle & Access

From: noyfb <noyfb_at_kma.com>
Date: Tue, 28 Sep 1999 15:22:25 -0700
Message-ID: <uabI3.2979$_X2.6404@client>

Yes,

You can link to the oracle table using ODBC You will need the ODBC Oracle Drivers
Once the Oracle table is linked it will look like any other Access table. Then you can use a query or DAO to update Data in it.

Gary

amerar_at_ci.chi.il.us wrote in message <7sqkui$8qc$1_at_nnrp1.deja.com>...
>
>
>
>Hello,
>
>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?
>
>Thanks,
>
>Arthur
>amerar_at_ci.chi.il.us
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Sep 28 1999 - 17:22:25 CDT