Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Data Retrieval Tool
and to move the "tables" from access you could use the "Migration
workbench" that you can get from OTN
/torben holm
Peter Gram wrote:
> Dennis
>
>
> Move the tables into Oracle and let the users use Access via odbc ;-)
>
> dmeng_at_focal.com wrote:
>
>> Good day all,
>> I have been asked the following question a couple of time by our
>> database
>> users -
>> They have a bunch of small Access databases that they want to port into
>> Oracle. Since most of these databases have just a few tables in them I
>> figure I can use sql loader to load the access tables into Oracle.
>> But the
>> tough part is, how do we have the users access the data once it is in
>> Oracle? Since these are pretty static databases and we don't have the
>> resources in house to develop front end tools to retrieve the data, I am
>> wondering if there is a slick, user friendly tool out there can help us
>> with this. Toad partially satisfies this need but I think it is an
>> overkill
>> for data access only. Also, it would be nice to have a web browser
>> interface and some data insert and update capabilities without using
>> sql.
>> Alright I know now I am really push it...
>>
>> TIA
>>
>> Dennis Meng
>> Database Administrator
>> Focal Communications Corp
>>
>>
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Torben Holm INET: torben.holm_at_miracleas.dk 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 Feb 06 2002 - 15:58:32 CST
![]() |
![]() |