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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,095,976
Messages
5,447,664
Members
405,462
Latest member
est1989

This Week's Hot Topics

Top