Re: oracle and exporting data for a .mdb file

"LHradowy" <laura.hradowy_at_NOSPAM.mts.ca> wrote in message news:Mar5b.71645$Rz6.94486_at_news1.mts.net...
> I don't have a great knowledge in oracle and trying to explain this might
be
> alittle confusing, so I apologize ahead of time.
> We are currently trying to cut a system over and I need to get some
> information.
>
> We currently have a proprietary system the exports data to software called
> MONARCH this then massages and preps the data into a .mdb file for input
> into an access database. (It is not in the budget to get rid of this
> database...)
>
> We are switching to an Oracle database (from the proprietary) but the data
> still needs to go the access database where it IS EXPECTING a .mdb file.
We
> can not change this, as this will be considered a change request and more
> money, so I begin here. Can oracle do it, and where can I find out how to
do
> it?

Laura,

you maybe able to do this using Oracle's migration workbench for MS Access (which is free). One of the things it's built in "wizards" can do is take tables and data from within an access .mdb file, recreate and populate them in an Oracle database, and then replace the Access tables with links via odbc to the Oracle tables. This allows applications to continue to function via the Access .mdb file even though the data is all held in Oracle.

See http://otn.oracle.com/documentation/migration.html for ducumentaion and software.

Paul Dixon Received on Thu Sep 04 2003 - 06:25:03 CDT