Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle and exporting data for a .mdb file
LHradowy wrote:
>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?
>
>
>It was mentioned that PowerBuilder can do this, so can oracle do this as
>well?
>
>Thank you for any info.
>
>Laura
>
>
>
>
Connect Access to Oracle using Oracle's ODBC driver and then, in Access,
write SELECT statements to load the tables.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Sep 04 2003 - 00:14:15 CDT