what is the best performing way to uplaod data from Excel to a DB such as Oracle using VBA/ADODB.
At the moment the best way I found is a loop on all Excel row to craete an INSERT INTO XXX SELECT XXX FROM DUAL UNION SELECT XXX FROM DUAL UNION ...
VBA insert in a temporary table and then runs a store procedure that check data and insert into the desired table.
Who can suggest a different and best performing appoach?
August 1, 2012 12:20 PM