Re: Moving MS Access Data to Oracle Clinical
Date: Mon, 7 Feb 2000 09:59:52 -0000
Message-ID: <87m521$8pi$1_at_soap.pipex.net>
<jkort_at_my-deja.com> wrote in message news:87ael4$899$1_at_nnrp1.deja.com...
> My apologies if this is the wrong forum for this question. I need to be
> able to export data from a MS Access database so that it can be imported
> by a client using Oracle Clinical. I have no Oracle or Oracle Clinical
> experience, and have searched extensively trying to find any docs that
> deal with this subject. I assume I can put out some kind of a flat file
> - but what sort of format would it need?
>
> TIA for any help!
> Jack Ort
You could push your data using an ODBC link to the Oracle Tables
OR if you output a .csv then your DBA should be able to load it using the
Oracle utility
SQL*Loader. In fact you could probably load jsut about any flat file format
with SQL*loader given enough patience.
Received on Mon Feb 07 2000 - 10:59:52 CET