Sam OZ
asked on
Write to Excel file from two databases
Hi I have a table TB_Doc in an Oracle 11g database. Also I have TB_Doc in an sql database ( two databases in different DB servers)
I need to run a query select Plant, Count(DocNo) from TB_Doc group by Plant on both databases
How can I output the result of the two queries in the same excel file (Kept in a networkpath)
Excel file has predefined template for first two rows . So the data (excluding header) need to be written from row 3
Column A, B to be written from Oracle. Column D,E to be written from Sql Server
(Currently I do copy paste the results. But there are several count match reports I need to generate of this kind. So It would help, if it can automate)
I need to run a query select Plant, Count(DocNo) from TB_Doc group by Plant on both databases
How can I output the result of the two queries in the same excel file (Kept in a networkpath)
Excel file has predefined template for first two rows . So the data (excluding header) need to be written from row 3
Column A, B to be written from Oracle. Column D,E to be written from Sql Server
(Currently I do copy paste the results. But there are several count match reports I need to generate of this kind. So It would help, if it can automate)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.