Adding double quotes to text in Excel

If you have ever worked with drop down lists in Sage ACT, you know that you can import items to populate the list.  The list has to be a text file with the items one per line, enclosed in double quotes. I like to use Excel to key in the data, sort it, remove duplicates, […]

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

  • 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!