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