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_at_news2-win.server.ntlworld.com>
Date: Wed, 6 Dec 2000 15:55:00 -0000
Message-ID: <kntX5.736$4N5.10939_at_news2-win.server.ntlworld.com>
-
[Quoted]
- install oracle client and odbs drivers onto PC [Quoted] [Quoted] 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 - 16:55:00 CET