Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was wondering if a trigger created via sql in Oracle would perform faster
than the equivalent vba function in excel that is uploading to Oracle? Either way I am running a program to upload data into Oracle using VBA. I was thinking of making some of the Excel VBA tasks the database's tasks through a trigger, but in order to do that I have to do the "work aorund" for Oracle so I can work on the same table. I experimented with a small dataset and when using triggers, the program time seemed to triple if not more. Any thoughts? Thank you. Brent |