Re: Oracle 7.3 to Access97

There are 2 ways to make Oracle data available to Access - 1: as a linked table - That is a 'replication' of the data structure ( field names, types etc ) that can be treated as an Access table but is actually an ODBC connection link to the actual data which remains in Oracle

2: as an imported table - it uses ODBC to copy an Oracle table into an existing Access database...from there on, its just another Access table

Both these methods need an ODBC/SqlNet installation for the client and the user must, as usual, have sufficient rights to the Oracle database tables..

Access can also export data TO an Oracle database, using the ODBC/SqlNet connection, but be sure to have ONLY upper-case Table names in your Access table before exporting - many Oracle tools ( like SqlPLus ) dislike mixed-case table names....

In Access these methods can be accessed by the Table..New... sections and the File..SaveAs/Export menus

Hope it helps,
John Greco
Email to john.greco_at_dot.state.mn.us

Patricia <pchervas_at_hotmail.com> wrote:

>Can any one please tell me how to load data from
>Oracle (7.3.2) to Access 97 and vice versa.
>I have some tables in Oracle database and the user
>requested it to be available in MS Access.
>I am on Win 95.
>
>Thanks.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Jul 19 1999 - 09:50:41 CDT