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.

Formed in 2005. the 90 Minds Consulting Group is a collaboration of 130+ Sage partners who independently join together online in a 24 x 7 private network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.

Share

Need More Help?

The 90 Minds Group offers members in almost every area of the country. We provide consulting services on-site or remotely.
Would you like additional assistance?

Click Here To Contact Us


Speak Your Mind