AW: MS Access from Oracle
No, but the other way round is possible. Open Access MDB and link your needed oracle tables via ODBC. Then you can query both, Access and Oracle tables. Volker Schoen INPLAN RUHR Informationstechnik GmbH Tel.: +49 208 / 65 91 - 950 Fax: +49 208 / 65 91 - 980 E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Eberhard, Jeff [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 3. September 2002 22:39 An: Multiple recipients of list ORACLE-L Betreff: MS Access from Oracle Can someone tell me where to start to find out how to access an MS Access table from Oracle. Basically what I want to do is be connected to an Oracle database in SQL*Plus and execute a query against an MS-Access table. Is this possible? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access from Oracle
Doc ID: 109730.1 -Original Message- Sent: Tuesday, September 03, 2002 5:08 PM To: Multiple recipients of list ORACLE-L Search on Metalink for 'Heterogenous Services'. The documents there describe how to setup a dblink to an MS Access database. HTH, Beth -Original Message- Sent: Tuesday, September 03, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Can someone tell me where to start to find out how to access an MS Access table from Oracle. Basically what I want to do is be connected to an Oracle database in SQL*Plus and execute a query against an MS-Access table. Is this possible? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MS Access from Oracle
Search on Metalink for 'Heterogenous Services'. The documents there describe how to setup a dblink to an MS Access database. HTH, Beth -Original Message- Sent: Tuesday, September 03, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Can someone tell me where to start to find out how to access an MS Access table from Oracle. Basically what I want to do is be connected to an Oracle database in SQL*Plus and execute a query against an MS-Access table. Is this possible? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MS Access from Oracle
Can someone tell me where to start to find out how to access an MS Access table from Oracle. Basically what I want to do is be connected to an Oracle database in SQL*Plus and execute a query against an MS-Access table. Is this possible? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
