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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: getting data from an access MDB file into Oracle

RE: getting data from an access MDB file into Oracle

From: bill thater <thaterw_at_telergy.net>
Date: Wed, 24 Jan 2001 14:33:03 -0500 (Eastern Standard Time)
Message-Id: <10751.127401@fatcity.com>


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.
Received on Wed Jan 24 2001 - 13:33:03 CST

Original text of this message

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