Re: importing data from an external source

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 <EUVT4.37555$wz3.114262_at_newscontent-01.sprint.ca>,   "Xiang Gao" <cgao_at_sprint.ca> wrote:
> Oracle has a tool called Oracle Migration Wizard. It works well with
 our
> Access to Oracle migration. You can try to see if it will work.
>
> Craigers wrote in message <8fp71o$knf_at_gap.cco.caltech.edu>...
> >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