Pull data directly from Sage 100 into Microsoft Excel for business intelligence analysis without any 3rd Party Add-Ins. By: Tekoa Software Sage 100 ERP MAS90 MAS200 data can easily be pulled directly into Excel. Excel can perform this functionality without any third-party add-ins or tools. Use the Excel built-in data tools to pull live Sage 100 ERP data into a spreadsheet, then analyzed the data and write reports using Excel. This allows you to use Excel to: Create Pivot Tables of Sage MAS data Quickly Filter and Sort Sage 100 data Easily Analyze data Build Excel Worksheets that reference live Sage 100 ERP data 1. Open a new Excel spreadsheet and go to the Data tab. Select the From Other Sources dropdown and select From Data Connection Wizard. 2. Select ODBC DSN. 3. Select SOTAMAS90, which is the Sage 100 ERP ODBC driver name. 4. Login to Sage 100 using credentials that have access to the ODBC files you want. 5. Select any Sa...
Accounting Software and ERP Systems