RE: getting data from an access MDB file into Oracle

Thanks Ruth. Excatly right - there's a metalink article on it. 109730.1 I am trying to test it out and getting various errors - mostly to do with unable to resolve service names .. I am not clear no it yet though.

There will be more to come later.

adam

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Wednesday, January 24, 2001 3:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: getting data from an access MDB file into Oracle

This looks like you want a database link. RBG ----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 24, 2001 2:35 PM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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