Re: importing data from an external source

From: <gjlinker_at_geocities.com>
Date: 2000/05/28
Message-ID: <8grd1c$p56$1@nnrp1.deja.com>#1/1

To upload a spreadsheet full of data into an Oracle table you could use Oraxcel. I've implemented Oraxcel such that errors (due to constraint violations e.g.) are recorded next to a row. It will collect all errors at the top of the spreadsheet so you can find/fix/repost the rows in error more easially.

Have a look at it at http://www.oraxcel.com

Regards, Gerrit-Jan Linker
http://www.oraxcel.com

In article <8fp71o$knf_at_gap.cco.caltech.edu>, "Craigers" <dotacion.nospam_at_st-helena.zzn.com> wrote:
> Is there a support utility that Oracle uses to import into the
database? We
> want to bring external cash transactions captured and recorded on an
Excel
> spreadsheet directly into AP_INVOICES instead of manual entry.
>
> All ideas and suggestions welcome....
>
> --
> Craigers ...
> Oracle Environment 7.3.4 NCA
> Solaris
> Designer Reports 2.5 Forms 4.5
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun May 28 2000 - 00:00:00 CDT