RE: Data Retrieval Tool

One option is to look into Oracle's Migration Workbench. It's a free download from Technet (technet.oracle.com). It can take an existing Access datrabase, create the same tables in an Oracle schema, move the data to the Oracle tables, and so on. I've used it and it works well.

One option it offers that I haven't used is to modify existing Access forms to use the new Oracle tables instead of the old Access database. I assume via ODBC.

So in theory, your users could keep using their existing Access forms to update the Oracle data while you work on moving them to a different front end.

Dave

> -----Original Message-----
> From: dmeng_at_focal.com [mailto:dmeng_at_focal.com]
> Sent: Wednesday, February 06, 2002 11:13 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Data Retrieval Tool
>
>
> 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:
> INET: dmeng_at_focal.com
>
> 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: 
  INET: schmoldt_at_fyiowa.com

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