Running SQL Query from within Excel using OTA?



I have some monitoring SQL queries to run against SiteAdmin and/or individual ALM project databases. Management is now asking for a way to run these queries from within Excel. Looked around and noticed everyone using OTA APIs for reporting when it comes to Excel but my problem is different as it has to be SQL query so I am looking for direction how to run SQL query from within Excel. It will be like user having TDAdmin privileges clicking on a button for SQL to run and pull data in same or new spreadsheet


PS: I'll be using TDAdmin account to run queries as I dont have a DB account so direct connectivity to DB via ODBC is a no go unfortunately. Any sample code or high level view is highly appreciated. All I need to know is how to execute SQL and save results in Excel assuming TDConnection is used for connection.




Parents Reply Children