Re: oracle and exporting data for a .mdb file

From: Daniel Morgan (damorgan_at_exxesolutions.com)
Date: 09/04/03 

Date: Wed, 03 Sep 2003 22:14:15 -0700

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@x.washington.edu
(replace 'x' with a 'u' to reply)

Relevant Pages

  • Re: oracle and exporting data for a .mdb file
    ... > We are switching to an Oracle database but the data ... > still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ...
    (comp.unix.programmer)
  • Access and Linked tables to Oracle
    ... In the past I created an Access database front end for our end users ... for the purposes of querying our Oracle data. ... Something around 2 seconds if Oracle has cached the query ... is getting defined for the primary key in the large Oracle table. ...
    (microsoft.public.access.tablesdbdesign)
  • oracle and exporting data for a .mdb file
    ... I don't have a great knowledge in oracle and trying to explain this might be ... MONARCH this then massages and preps the data into a .mdb file for input ... still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ...
    (comp.unix.programmer)
  • Re: oracle and exporting data for a .mdb file
    ... > still needs to go the access database where it IS EXPECTING a .mdb file. ... Can oracle do it, and where can I find out how to ... But, given your constraints, what I would do is connect a Windows machine ...
    (comp.unix.programmer)
  • Re: oracle and exporting data for a .mdb file
    ... you can connectdirectly to your Oracle tables via ODBC. ... > still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ...
    (comp.unix.programmer)