I need to use VBA to populate a Worksheet with the results of a simply query against a table.
Do I need a stored procedure to return the values?
Besides a connection string to access the Oracle Database, what else do I need?
I have the SQL tested in SQL Tools.
Please let me know.