This looks like you want a database link. RBG
----- Original Message -----
From: "bill thater" <thaterw_at_telergy.net>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, January 24, 2001 2:35 PM
Subject: RE: getting data from an access MDB file into Oracle
> On Wed, 24 Jan 2001,Adam Turner scribbled on the wall in glitter crayon:
>
> ->Looks interesting. Ideally what I would like to do is pretty simple ...
I
> ->was hoping to do something like
> ->
> ->select * from dbo.tableIneed from adam_at_remoteAccessDB
> ->
> ->is there something like that out there? The word gateway comes to mind,
but
> ->I can't seem to find much on technet about it.
> ->
> ->
> ->thanks
> ->
> ->adam
>
> if you are using access, you can just link the ORACLE table in and then
treat
> it like an access table.
>
>
> --
> Bill Thater Certified ORACLE DBA
> Telergy, Inc. thaterw_at_telergy.net
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "We are different, in essence from other men.
> If you want to will something run 100m.
> If you want to experience something run a marathon"
> Emil Zatopek
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> As of next week, passwords will be entered in Morse code.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: bill thater
> INET: thaterw_at_telergy.net
>
> 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: ListGuru_at_fatcity.com (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).
Received on Wed Jan 24 2001 - 14:14:45 CST
