Viewing custom dashboards on the Web

I just learned something and thought I’d pass it along to people who are interested in Sage ACT dashboards and viewing them on the web. Behind the scenes, there is an XML file located in the Tools folder under Program Files that controls what templates are available for building dashboards in Sage ACT.  You can […]

Using SQL commands in Excel – Drilling down into ACT data

Today’s blog is about using SQL commands directly in Excel.  I am going after data in Sage ACT, but you can use the same technique to go after a wide variety of data sources that are SQL based. First off, open Excel.  I am showing you screen shots from Excel 2010.  You want to click […]

Output SQL to CSV

A while ago, I posted a blog article about building CSV’s from SQL tables.  It was a very popular post, so I’m submitting it again.  I decided to go research if there were any things to do differently with the new SQL Server 2008. Turns out what I wrote before still applies. What drove me […]