Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help for MS Access connection to Oracle 7.3 on Unix
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