Link to home
Start Free TrialLog in
Avatar of jmerulla
jmerullaFlag for United States of America

asked on

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?

thanks
Avatar of jmerulla
jmerulla
Flag of United States of America image

ASKER

Figured it out.  There's an export to excel button. Now how do I close this question?
ASKER CERTIFIED SOLUTION
Avatar of PAQ_Man
PAQ_Man
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of PUTTERER
PUTTERER

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.