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

Home -> Community -> Usenet -> c.d.o.misc -> Access 97 to connect to Oracle Dbase

Access 97 to connect to Oracle Dbase

From: RamSC <ramsc_at_goplay.com>
Date: Wed, 12 May 1999 18:53:55 -0800
Message-ID: <nbr_2.5495$me.2306291@WReNphoon4>


Hi RNK:
The short answer is yes. You use the File/Get External Data/Link Tables to put the Oracle table in your Access Database as an external linked file.

The long answer is that you have to have the Oracle ODBC drivers setup.

Good luck. You will have to live with the data constraints setup in your Oracle data.

I do a lot of data conversions to Oracle at my work and use this quite a bit because of the ease of queries and data manipulation in Access.

Robert
ramsc_at_goplay.com

   -**** Posted from RemarQ, http://www.remarq.com/?a ****-  Search and Read Usenet Discussions in your Browser - FREE - Received on Wed May 12 1999 - 21:53:55 CDT

Original text of this message

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