Re: oracle and exporting data for a .mdb file

From: Marc Rochkind (rochkind_at_basepath.com)
Date: 09/03/03 

Date: Wed, 03 Sep 2003 14:18:44 -0600

On Wed, 3 Sep 2003 14:21:16 -0500, LHradowy <laura.hradowy@NOSPAM.mts.ca>
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
>
>
>

As this is a UNIX newsgroup and I assume you are asking how to produce the
MDB file on UNIX, I'm afraid I can't help you... I haven't a clue how to do
this, nor do I know whether Oracle can do it.

But, given your constraints, what I would do is connect a Windows machine
to the UNIX machine (via a network) and produce the MDB file on Windows.
It's very easy to do this on Windows with various technologies, such as
ODBC with the Access driver.

Use whatever is most convenient for the connection between Oracle and the
Windows program. It might access Oracle directly, or perhaps you can have
an intermediate file using CSVs or XML or whatever.

--Marc

Relevant Pages

  • Re: oracle and exporting data for a .mdb file
    ... >still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ... Can oracle do it, and where can I find out how to do ...
    (comp.unix.programmer)
  • 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)
  • 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 Personal Edition Sucks!
    ... computer world, instead it has it's own crappy java based installer, ... look at your registry before and after Oracle got done trading the soul ... Subject: WIN: Manually Removing all Oracle Components on ... Microsoft Windows Platforms ...
    (comp.databases.oracle.server)
  • Re: Installing 32-bit and 64-bit oracle client on windows 2003 Server
    ... Windows services to connect to the oracle database server hosted on HP- ... if you want to install 2 different clients you need to install ... and hit the documentation button. ...
    (comp.databases.oracle.server)