Error in getting data out of MAS 90 / MAS 200 AKA Sage 100 to Microsoft Excel

By | August 31, 2016

In our previous few blogs we discussed about the migration of Sage 100 to Sage 300.

New Stuff: Migrate customer from Sage 100 ERP to Sage 300 ERP.

Today, we will discuss about the error we received in fetching Sage 100 data using Microsoft Excel. We were trying to import data into Excel from Sage 100 and during this process after selecting MAS90 DSN received below error.


After applying various solutions for couple of hours finally we got below solution which was helpful for this error. Actually this error was occurring because we were connecting Sage 100 DSN through OLEDB (i.e. Data -> From Other Sources -> From data connection wizard) and Sage 100 DSN only connect through the ODBC. There is one option named ‘From Microsoft Query’ which can be used to connect Sage 100 Company’s database from Excel. We used this option and able to import data into Excel successfully.

We got solution for above error from below forum
https://sagecity.na.sage.com/support_communities/sage100_erp/f/97/t/37041

Note: This could be work with 32 bit Microsoft Excel only.

About Us
Greytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique solutions of Sage 100 integration with Sage CRM, and Salesforce.com along with Sage 100 Migration from Sage 50 US, Sage Intacct, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more details on Sage 100 Services, please contact us at sage@greytrix.com. We will be glad to assist you.