Category Archives: How-To’s
How-to Connect Excel to an External Data Source
For quick and dirty SQL reports, it’s hard to beat dedicated tools such as WinSQL, SQuirrel SQL, or AQT. However, if you find yourself running the same query on a regular basis and then manually importing the results into Microsoft … Continue reading
How-to Compare Two DB2 Tables Using EXCEPT SQL Function
The other day someone was showing me how Advanced Query Tool (AQT) can be used to compare the data in two tables. I started wondering if such a thing could be done using generic SQL or if one had to … Continue reading
Outlook Macro Stops Working (or Doesn’t Work to Begin With)?
A day or two after setting up my Outlook GTD macros (as explained here), they stopped working. When I clicked on the macro in the toolbar, used the shortcut keys, or clicked the macro icon in the Quick Access toolbar … Continue reading
Using Outlook Macros to Move Email Items to Another Outlook Folder
When my work PC came off lease I took the necessary steps to back up my documents, IE favorites, etc. so I could add them on the new machine. After getting the new machine (and turning in the old one), … Continue reading