Re: Using Access to View Oracle Data

From: Richard Bragg <richard.bragg_at_ntl.com>
Date: Wed, 6 Dec 2000 15:55:00 -0000
Message-ID: <kntX5.736$4N5.10939@news2-win.server.ntlworld.com>

install oracle client and odbs drivers onto PC 2)set up an ODBC datasource to point to your database/schema 3)In access you can now create a link table that is a local object that stores it's data in oracle. I think just use the insert | table select link table in file type scroll down to ODBC source follow the prompts really.

You maybe able to port the data over to access, change it but I don't know yet how you would send it back.

A link table will preserve all the rules you have in Oracle, constraints etc. There are probably down sides but I am not an access person. Just been playing as proof of concept.

"Jerry" <america_at_usa.com> wrote in message news:eetX5.2694$NB1.68850_at_news2.atl...
> Is there a way to use Access to view Oracle table data. I
> might want to load data into Access table, manipulate it,
> then export it back to the Oracle table. Can this be done ?
> Step by step how do you do this
>
>
Received on Wed Dec 06 2000 - 09:55:00 CST