1 Attachment(s)
SQL output from Excel VBA macro
I have some requirement on excel macros.
Suppose I have a table named "Employee" and schema named "HR" in ORACLE database.
Schema name and table name should be in list-box (like attached pic).
Now I want to display the selected columns output row after clicking "SQL" button like below image.
Is it possible to do in excel macro?
Attachment 719
example :
If I select column c1, c2 and c4 from "HR"."Employee" table, in back end the query should fire 'select c1, c2, c4 from "HR"."Employee" ' from database. And these c1, c2 and c4 is not fixed I may increase or decrease column count from front end so It should generic.
