• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code to run SQL queries in Oracle SQL Developer 1.5.1

sn152

sn152

Member
Hi All,

I have a question.


I have Oracle SQL Developer 1.5.1. I want to run certain SQL queries in 4 different schemas. And copy the results into an excel file in different sheets. Is there a way to do this using VBA? If Yes, How? Please advice.


Thanks in advance!
 
There are lots of ways to do this but, by the sounds of it, the answer you're probably looking for is to use ADO to run queries against the database
 
Hi Colin, Thanks very much for your reply. Actually I have a work to b done everyday at a scheduled time. The work is to run a set of queries in SQL developer and copy paste the data in an excel sheet. Likewise I have to run SQL queries in multiple schemas and copy paste the data in excel. How can this be done. Pls help.

Thanks in advance!
 
You must log in or register to reply here.
Back
Top