Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Load Questions
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
LLLLLLLLLLLLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLLLLLLLLLLReceived on Sat Feb 20 1999 - 18:11:05 CST