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

Home -> Community -> Usenet -> c.d.o.server -> Re: Need help for MS Access connection to Oracle 7.3 on Unix

Re: Need help for MS Access connection to Oracle 7.3 on Unix

From: Patrick Tan <ptan_at_mindspring.com>
Date: 1998/04/17
Message-ID: <353771AE.208A2389@mindspring.com>#1/1 







Frank,


   You open a Access file, goto File -> Get External Table ->Link Table,
choose ODBC Databases() at Files of Type combo box, choose the Data
Source for Oracle ODBC drive, enter userid, password and server name.
You will get a list of tables and views and choose the tables you want
to use in access. I assume you installed SQLNET in your pc and have
tnsnames.ora.



Patrick
Received on Fri Apr 17 1998 - 00:00:00 CDT












Original text of this message













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