Re: Exporting data to Access

From: Philippe Leroux <leroux_at_mail.edi.fr>
Date: Wed, 04 Dec 1996 14:44:36 +0100
Message-ID: <32A58044.4558_at_mail.edi.fr>


Jay D. Sullivan wrote:
>
> Hello,
>
> We need to export data from an Oracle 7 database and import it into
> Microsoft Access. We will be unable to connect to the database directly
> from Access so, ideally, we would like to export the data from Oracle to
> an export file which Access can read. It looks like the Oracle Export
> utility only exports an Oracle-specific file which Access cannot read.
> Are there any other utilities or tools which will allow us to create a
> simple comma delimited export file from Oracle?
>
> Thanks,
> Jay Sullivan
> Economic Analysis Group, Ltd.

Perhaps can you use ODBC Drivers ! It works fine under Access, and you can work with Oracle tables like Access tables. Which environment do you have ?

leroux_at_mail.edi.fr Received on Wed Dec 04 1996 - 14:44:36 CET

Original text of this message