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 […]

  • Been sent a support request?

    Click here to enter your ticket number: Ticket

  • Our Business

    Our Mission
    Bridging the gap between technology and business processes. Provide quality business consulting, with an emphasis on technology, maintain superior client relationships and enjoy the trust and respect of our clients

  • Us in a nutshell

    Swiftpage
    CRM applications
    Data Conversion
    Custom Programming
    SQL Experts
    Lotus Notes
    Quotewerks
    Stonefield Query
    MS Office Programming
    Business analysis
    Process Workflow
    Social Media and SEO
    Linux, Mainframe
    Been there, done that



  • Facebook Like Us!