I need a quick VBA routine written into a spreadsheet. Functionality as follows:
1. Read a certain column cell by cell downwards till the end of the data and copy all the values into a variable as a single string. (This is a SQL statement per screen shot)
2. Execute the SQL statement against an Oracle database (connection string to be hardcoded)
3. Put the resulting recordset, row by row, into sheet 1 from a predefined starting row.
I anticipate this is a quick 2hr task for someone who has the right skillset.