SQL output from Excel VBA macro

[goldenbutter]

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?

SQL_Excel.jpg

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.

[goldenbutter]

any help guys....

[Admin]

Hi

Have a look at connectionstrings.com

[goldenbutter]

any particular link can you provide??