I would like to execute an Oracle sql in Excel 2010 using ODBC. Connection to the database works but I am not sure how to run the script.
'This is a test', Name
(select somevalue from someview where field1 = '&val1' and field2 = '&val2' and field3 = '&val3') value3
The results should then populate the worksheet.
Thanks in advance.