Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: synchronize MS Access and Oracle tables
I have no idea how to do from Access to Oracle. But from Oracle, you can try
the following:
1. Write a java program that can access MS-Access through JDBC 2. Load it into your Oracle database and create a pl/sql wrapper. 3. Call it from a database trigger or procedure etc within Oracle. Thereshould be many examples in $ORACLE_HOME/jdbc/demo/samples folder on how to use JDBC with oracle.
"Jeff Y. Y." <yuanjeff_at_yahoo.com> wrote in message
news:a2bc9497.0204130907.5d88b2f6_at_posting.google.com...
> Hi,
>
> We have two applications by two vendors: one in Oracle 8.1.7 and one
> in MS Access. We have to make them talk with each other. The goals are
> once data are inserted into Oracle, some of them will be sent to
> Access for updating Access tables. On the other hand, once data are
> inserted into Access, some of them will be inserted into Oracle. The
> two directions should be automatic, or in real-time synchronization.
>
> One of the solutions may be create a link between MS Access and
> Oracle, and then do some "mapping". My questions will be
> 1. Can the database link do the both directions?
> 2. How can I create the links?
> 3. What should I install to so that? It will be great if you could
> ponit me to some documents.
>
> Thanks a lot.
>
> Jeff
Received on Sat Apr 13 2002 - 19:31:18 CDT