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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!