Re: Moving MS Access Data to Oracle Clinical

From: Niall <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 7 Feb 2000 09:59:52 -0000
Message-ID: <87m521$8pi$1@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 - 03:59:52 CST