Multiple DB Query in same workbook.

[dolphine420]

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