Hi, 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?

Software/Hardware used:
EXCEL ORACLE