I am trying to automate some excel exports from Toad Data Point. I have various tables which I need to export to similarly named excel spreadsheets. I am trying to use Select to File in automation.
I’m struggling with the syntax in the SQL (i.e. the table name). So for example - say my table name is STWL167 and the spreadsheet I need to write to is STWL167 too.
Is it possible to insert a variable (using a loop) into the SQL statement to select which table to extract and which spreadsheet to write to?
I believe the latter is possible but I’ve not seen any examples of using the variables for a table name?
Thanks for any help you can give