Re: SQL*Load Questions

From: Gjlinker <gjlinker_at_aol.com>
Date: 21 Feb 1999 00:11:05 GMT
Message-ID: <19990220191105.07007.00000370@ngol06.aol.com>

Dear all,

>Alternatively, I have used Excel macros to populate data tables, but without
>any error trapping ability in the macros there is no way to easily handle
>typos and incorrect entries in the spreadsheet data. Does anyone have a way
>for Oracle to feed 'status' messages back to the Excel macro to trap these
>types of errors?

This is exactly one of the features of Oraxcel, my addin for Excel. Oraxcel lets you load data from a spreadsheet into an Oracle table. All failures are collected with the error number+description so you can easially retry them.

Please have a look at Oracel at http://members.aol.com/gjlinker

Regards Gerrit-Jan Linker,
Linker IT Consulting Limited.

---

*| Gerrit-Jan Linker : gjlinker_at_aol.com
*| 
*| http://members.aol.com/gjlinker

*| 
*| Developer of:
*| Oraxcel, OraWeb, OraSQL, OraCodes and OraDebug
*************************************************
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT

LLLL

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

L Linker IT Consulting Ltd L

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

Received on Sat Feb 20 1999 - 18:11:05 CST