Excel Pragma

I do like Infocenter. I do. It is liberating writing the queries on and on again and correcting the typos and other structural glitches. But then again, what if you had your standard queries, all of them in a dropdown box, with all of your KTP databases (production and test) in another dropdown box and you could import all of the data into an Excel spreadsheet immediately ? tada ! enters KTP Data v1.0 module.

All of the dropdown data is obviously configured in a “Config” sheet where all the KTP databases, connection strings and SQL queries are configured and obviously fed into the dropdown boxes :

Click on “Retrieve” and the data gets directly fed to the spreadsheet.

Obviously, there’s always the need to retrieve data from the same tables of two different databases, hence the options of :

IF any of you has worked on KTP, I appreciate the comments and suggestions.