To export data, use either internal applications or external ODBC compliant programs using the following ODBC drivers.

• MAS 90 4.0 ODBC Driver (Sage 100 4.10 and higher)
• MAS 90 32-bit ODBC Driver (Sage 100 4.05 and earlier)

The "SOTAMAS90" user DSN is created automatically using the appropriate driver when Sage 100 is installed or when Workstation Setup is run. To verify the drivers, perform the following:

1. In Windows, open Start / Control Panel / Administrative Tools / Data Sources (ODBC).
2. Click the 'User DSN' tab and verify that "SOTAMAS90" exists. Note the assigned driver.
3. Click the 'Driver' tab and verify that the driver that assigned driver is listed.

The following is a list of applications that can be used to export data from Sage 100 :

• External software:
  • Microsoft Access
  • Microsoft Excel
  • Crystal Reports
  • SQL Server DTS
  • Any ODBC compliant application that can extract data through a DSN.
• Sage 100 applications:
  • Visual Integrator (Can also import data)
  • Exchange (General Ledger only. Can also import data)
  • Report Master (Obsolete/retired. Not available for modules upgraded to Level 4 standards)
  • Reports (Select "Export/Email" from the printer drop-down box.)

Use the following resources for Sage 100 information:

• The user guide, Online Help, or "What's This" Help within the program.
• Knowledge base for specific issues.
• Sage Software training courses.
• Your Sage Software business partner. If you do not have a business partner, contact Sage Software ClientCare for the name of a partner who can assist you.

DocLink: How to create a silent connection to an ODBC data source
DocLink: How to find or access additional Crystal Reports resources and help for Sage 100
DocLink: How to access File Layouts (field and table schema) or the TRSG (Technical Reference and Support Guide) for Sage 100 ERP
DocLink: How to export standard (non-graphical) reports from Sage 100 ERP
DocLink: How to export reports from within Crystal Reports Designer
DocLink: How to import and export Accounts, Budgets &/or Transactions into the General Ledger using General Ledger Exchange
DocLink: How to access Visual Integrator resources and Help for import and export of data
DocLink: How to import data into Microsoft Access or Excel from Sage 100