{"id":1039,"date":"2016-08-31T05:36:37","date_gmt":"2016-08-31T05:36:37","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1039"},"modified":"2024-07-16T11:21:52","modified_gmt":"2024-07-16T11:21:52","slug":"error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/","title":{"rendered":"Error in getting data out of MAS 90 \/ MAS 200 AKA Sage 100 to Microsoft Excel"},"content":{"rendered":"

In our previous few blogs, we discussed the migration of Sage 100 to Sage 300.<\/p>\n

New Stuff: <\/strong>Migrate customer from Sage 100 ERP to Sage 300 ERP.<\/a><\/p>\n

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 the below error.<\/p>\n


\n<\/a>\"import<\/a>After applying various solutions for a 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 \u2018From Microsoft Query\u2019 which can be used to connect Sage 100 Company\u2019s database from Excel. We used this option and able to import data into Excel successfully.<\/p>\n

\"Connecting<\/a><\/p>\n

We got solution for above error from below forum
\nhttps:\/\/sagecity.na.sage.com\/support_communities\/sage100_erp\/f\/97\/t\/37041<\/a><\/p>\n

Note: This could be work with 32-bit Microsoft Excel only.<\/em><\/strong><\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/a> 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.<\/p>\n

Greytrix\u00a0has some unique solutions of\u00a0Sage 100 integration with Sage CRM<\/a>,\u00a0and Salesforce.com<\/a> along with Sage 100 Migration from Sage 50 US<\/a>, Sage Intacct<\/a>, QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n

For more details on Sage 100 Services, please contact us at\u00a0sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In our previous few blogs, we discussed 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\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[177],"tags":[287,401,466],"class_list":["post-1039","post","type-post","status-publish","format-standard","hentry","category-sage-100-erp","tag-error-in-sage-100-to-excel","tag-sage-100-to-excel","tag-sotamas90"],"yoast_head":"\nGetting data out of MAS 90 \/ MAS 200 AKA Sage 100<\/title>\n<meta name=\"description\" content=\"Know about the error we received in fetching Sage 100 data using Microsoft Excel. We were trying to import data into Excel from Sage 100\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting data out of MAS 90 \/ MAS 200 AKA Sage 100\" \/>\n<meta property=\"og:description\" content=\"Know about the error we received in fetching Sage 100 data using Microsoft Excel. We were trying to import data into Excel from Sage 100\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-31T05:36:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-16T11:21:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/\",\"name\":\"Getting data out of MAS 90 \/ MAS 200 AKA Sage 100\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg\",\"datePublished\":\"2016-08-31T05:36:37+00:00\",\"dateModified\":\"2024-07-16T11:21:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Know about the error we received in fetching Sage 100 data using Microsoft Excel. We were trying to import data into Excel from Sage 100\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error in getting data out of MAS 90 \/ MAS 200 AKA Sage 100 to Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Getting data out of MAS 90 \/ MAS 200 AKA Sage 100","description":"Know about the error we received in fetching Sage 100 data using Microsoft Excel. We were trying to import data into Excel from Sage 100","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"Getting data out of MAS 90 \/ MAS 200 AKA Sage 100","og_description":"Know about the error we received in fetching Sage 100 data using Microsoft Excel. We were trying to import data into Excel from Sage 100","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2016-08-31T05:36:37+00:00","article_modified_time":"2024-07-16T11:21:52+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/","name":"Getting data out of MAS 90 \/ MAS 200 AKA Sage 100","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg","datePublished":"2016-08-31T05:36:37+00:00","dateModified":"2024-07-16T11:21:52+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Know about the error we received in fetching Sage 100 data using Microsoft Excel. We were trying to import data into Excel from Sage 100","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-content\/uploads\/2016\/08\/Untitled-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2016\/08\/31\/error-in-getting-data-out-of-mas-90-mas-200-aka-sage-100-to-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Error in getting data out of MAS 90 \/ MAS 200 AKA Sage 100 to Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=1039"}],"version-history":[{"count":5,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1039\/revisions"}],"predecessor-version":[{"id":5474,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/1039\/revisions\/5474"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=1039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=1039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=1039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}