Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle and Access

Re: Oracle and Access

From: Rob Calfee <trace_at_primenet.com>
Date: Tue, 28 Sep 1999 16:38:16 GMT
Message-ID: <37f0eec6.98112705@news.primenet.com>


Try linking the tables through ODBC in access and then create some sort of update query to update the linked oracle table(s).

On Tue, 28 Sep 1999 14:55:52 GMT, amerar_at_ci.chi.il.us wrote:

>
>
>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.

Rob Calfee
DBA
rcalfee_at_incsystem.com Received on Tue Sep 28 1999 - 11:38:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US