Re: Exporting data to Access

Jay D. Sullivan wrote:
> 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?

  You can use SQL*Plus to spool the data with some formatting. Alternatively, you can write a PL/SQL procedure to do that. (UTL_FILE can help you if you adopt the later approach).

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841