• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1552
  • Last Modified:

Export data out of mas90

Is there a way to export data out of mas90?  I need to run an employee history report (hire date, term dates) etc covering the past 7 years.  The information is in Mas90 but how do I get it out into an Excel or similar form?

1 Solution
jmerullaAuthor Commented:
Figured it out.  There's an export to excel button. Now how do I close this question?
Question Closed, 125 points refunded.
Community Support Moderator
You can use the Report Master to export to Excel as long as there are fewer than 16,000 records. That's a MAS90 limit.  Use the dBase format if there's more than 16K, I prefer dBase format anyway because there are column headings and text columns export as text even if they happen to be numeric text.

Custom Reports and all reports with the new native version 4.0 modules are Crystal based and can be exported to Excel with the export button at the top of the preview window.
You really don't need to export data from MAS90.  In Excel, e.g., you can simply go to Data/Get External Data/New Database Query.  Select SOTAMAS90.  You will see the familiar MAS90 logon prompt.  The rest is pretty self-explanatory.

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now