Re: Oracle and Microsoft access

Yes this is quite easy and I have a corporate application that does just this.

First, you link a table through access to oracle (get external data -> linked table -> pick ODBC as file type and select an ORACLE dsn).

The table should appear in your access database. If you double click on it you will have to login to oracle and the you can see the data.

Finally, open a connection to jet using the correct oracle ids and you can do selects and updates just like straight to oracle.

On Fri, 17 Mar 2000 12:30:54 -0500, Pierre Pavlenyi <pavlenyi_at_ca.ibm.com> wrote:

>Let me rephrase my question:
>
>I want to know if I can update the contents of a table in an Oracle database with
>the contents of a MS Access database using ODBC. i.e. MSAccess writes to Oracle.
>The table in Oracle already exists, and I _do not_ want to recreate it. I only want
>to repopulate it with the data from the MS Access table.
>
Received on Sun Apr 02 2000 - 20:11:07 CDT