I finally updated the database extension scripts that I originally posted eight years ago and added to the extension library.
The scripts make it easy to query different databases with little effort. Once the ODBC/OLEDB connection string is set up, it is just a matter of adding a reference to the top of the file. You then can execute queries against the database and direct output to either the log window or to IE. Other functions include generating Insert statements with optional upserts, running templates against SQL output, or running templates against text files. The scripts were written for SQL Server, but most scripts work against any ODBC/OLEDB connection, including excel. -- <http://forum.pspad.com/read.php?2,35782,63807> PSPad freeware editor http://www.pspad.com
