Multiple DB Query in same workbook.

dolphine420

New Member
Joined
Aug 31, 2018
Messages
1
Hi All,
I have 3 Oracle DB's (India, China, Japan)
I have written a macro which connects to DB & extracts records.
But I have to run each macro 3 times by changing the DB name.

Is there any way where macro automatically connects to 3 DB's and extract India records to Sheet1, China records to Sheet2 & Japan records to Sheet3 and save the workbook.

TIA
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,089,862
Messages
5,410,855
Members
403,331
Latest member
dignityy

This Week's Hot Topics

Top