My Excel file has a table linked to a temp.txt file. The data in the .txt file comes from a manually pulled report in TOAD.
I would like to have the .txt file updated automatically every morning. I would also like the temp.txt files to save a copy of itself to an archive folder with the format ReportA_yyyy_mm_dd.txt.
I've run SQL through Excel VBA before, but it seems less stable than TOAD. Are there any issues doing it through Excel VBA? Can I do it through TOAD, or something else entirely?
(There are actually 4 queries that need to be ran, but I assume if you can teach me to do one, I can do the others.)