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!

  Facebook Like Us!

•