Cloud Hosting For Sage 100 ERP

Sage MAS 90/200 Quick Tip from Zip: Excel Data(base) Query

Did you know that you can pull your Sage MAS 90/200 data right into Excel?!  This essentially enables you to create a dynamic Excel file that can be refreshed with the most up-to-date data.  

  1. Open a blank Excel document.
  2. On the Data menu, select “Import External Data”, then “New Database Query”.  (The Excel Data Query function doesn’t always get installed by default, so you may need to install it on certain workstations.)
  3. Pick the SOTAMAS90 odbc driver.  Typically it’s the one without an asterisk (*).
  4. Enter your MAS 90/200 login info, including the appropriate Company Code.
  5. You’ll then be presented with all your MAS 90/200 data files.  You can choose an entire data file or individual data fields within a file.
  6. Once you select your data file/fields, click Next.
  7. You can now specify 1 or more filters, or not.  Click Next.
  8. Now you can specify 1 or more Sort, or not.  Of course you can easily sort within Excel once your data is brought into the spreadsheet.  Click Next.
  9. Then you would typically have the data “returned to Excel”.  Click Finish.
  10. You can choose to put the data in your current spreadsheet, which is the typical method (into cell A1), or into a new Worksheet.  Click OK.  (If you click Properties, you’ll see the Options you have available.)
  11. You’ll then be prompted again for the Company Code and your MAS 90/200 login info. 
  12. Your data will appear.  Depending on the amount of data being Queried, it may take a short moment.

You can also pull your data into Access and lots of other applications that can utilize an ODBC data source.

Posted by Brett A. Zimmerman - www.brettzimmerman.com – Twitter: MAS90_Zip

© 2010, Brett Zimmerman. All rights reserved.

Virtual Private Cloud Hosting For Sage 100 ERP