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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Using Access to View Oracle Data

Re: Using Access to View Oracle Data

From: Mark Hannay <mhannay_at_cartech.com>
Date: Wed, 6 Dec 2000 13:47:28 -0500
Message-ID: <t2t2hpjkh7r4d6@corp.supernews.com>

1)To create the Access 97 link select File|Get external data|Link tables then a dialog box comes up.
2)Select Files of type|ODBC databases then select your Oracle ODBC database source (probably under Machine Data Source) 3) You'll then be prompted to logon to Oracle. You'll need your user name, password, and instance (server). You can then select the table(s) to link. 4) Now you can do an Access query on this table (it will look just like an Access table). Any changes made to the table or the results of the query on the table will update the Oracle database.

To load the data from Oracle into an Access table, you'll have to use code. Open the Oracle data as a "source" recordset and the Access table as a "target" recordset, then load your data. Then reverse the process to update Oracle.

Mark Hannay

Richard Bragg wrote in message ...
>1) 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 - 12:47:28 CST

Original text of this message

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