Re: Using Access to View Oracle Data

With linked tables it's easy to export data from Oracle to Access: Create a query in Access (sql view or assistant for table creating queries [please excuse: I only have a german version of Access97 and don't know the english captions for these menu-commands]):

Select column1,....,columnn INTO name_of_not_existing_access_table FROM name_of_the_linked_oracle_table;

Execute the query and the access-table should be created and filled. Writing back to the oracle-table can be done with an insert-query in Access:

insert into name_of_the_linked_oracle_table select * from name_of_generated_access_table;

(of course: if that doesn't violate constraints and the user has the privileges required).

Klaus

"Richard Bragg" <richard.bragg_at_ntl.com> schrieb im Newsbeitrag news:kntX5.736$4N5.10939_at_news2-win.server.ntlworld.com...
> 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 - 15:57:47 CST