<div>
hope anyone can assist on this
</div>


<div>
thanks! butler, this gets me nearly there
</div>


thanks! butler, this gets me nearly there

<div>
not the exact answer but got me in the correct direction,thaks
</div>


not the exact answer but got me in the correct direction,thaks

<div>
<div class="content wysiwyg-content">
folks<br />
<br />
on my oracle db i have &nbsp;a table called &quot;sql_statement&quot;, this includes the 2 columns called<br />
<br />
table_name and query_defintion and queryname i.e.<br />
<br />
table_name &nbsp; query_defintion &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; queryname <br />
countries &nbsp; &nbsp; &nbsp; &quot;where continent is europe&quot; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; europe &nbsp;<br />
<br />
i need to have my excel macro connect to the oracle db and then extract from the table called &quot;countries&quot; and extract the values of this object using the &quot;query_defintion&quot; from the &quot;sql_statement&quot; table called &quot;where continent is europe&quot; &nbsp;<br />
<br />
i.e.<br />
<br />
countries<br />
belgium<br />
germany<br />
italy
</div>
</div>


folks

on my oracle db i have  a table called "sql_statement", this includes the 2 columns called

table_name and query_defintion and queryname i.e.

table_name   query_defintion                             queryname 
countries       "where continent is europe"           europe  

i need to have my excel macro connect to the oracle db and then extract from the table called "countries" and extract the values of this object using the "query_defintion" from the "sql_statement" table called "where continent is europe"  

i.e.

countries
belgium
germany
italy

extract query in macro to excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.