{"id":20753,"date":"2016-04-08T08:24:52","date_gmt":"2016-04-08T14:24:52","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/axsupport\/?p=20753"},"modified":"2023-07-05T12:18:07","modified_gmt":"2023-07-05T19:18:07","slug":"dixf-importing-data-using-excel-and-odbc","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/","title":{"rendered":"DIXF &#8211; Importing data using Excel and ODBC"},"content":{"rendered":"<p>Consider a scenario where you are running <strong>AX 2012 R3<\/strong> and you want to <strong>import data from Excel files using ODBC. <\/strong>Having recently worked a case on this topic, I thought I\u2019d share some of the details on how this can be set up.<\/p>\n<p><span style=\"background-color: #ffff00\"><strong>1. Background<\/strong><\/span><\/p>\n<p>The main reason we were looking into this way of importing Excel data was that trying to import the data in <strong>Batch<\/strong> using <strong>Excel files<\/strong> would in some scenarios result in this error:<\/p>\n<p><span style=\"color: #ff0000\"><strong>The version of Microsoft Excel is not supported.-Exception from HRESULT: 0xC020801C<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20853\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png\" alt=\"S0\" width=\"341\" height=\"144\"><\/a><\/p>\n<p>Working with a <strong>LCS Repro VM<\/strong> we were able to reproduce the issue, and then establish&nbsp;an&nbsp;<span style=\"color: #339966\"><strong>alternative approach&nbsp;<\/strong><\/span>that I will outline below.<\/p>\n<p>There are <strong>lots of ways to import data into Microsoft Dynamics AX<\/strong> and this is only one of them. The best tool for the job and approach will depend on <strong>many factors<\/strong>, including the degree of control you have over source data&nbsp;formats (<strong>CSV File, Excel File, XML File, AX, ODBC<\/strong>), the frequency of the imports, the complexity of the entities being used, security considerations, etc.<\/p>\n<p>The aim of this blog post is simply to outline <strong>one<\/strong> approach which you may be considering.<\/p>\n<p><span style=\"background-color: #ffff00\"><strong>2. Prepare the environment<\/strong><\/span><\/p>\n<p>In this example, we are working with a very simple 2 column <strong>Terms of delivery<\/strong> entity <strong>Excel<\/strong> input file.<\/p>\n<pre><span style=\"color: #339966\">\/\/ Disclaimer:<\/span>\n<span style=\"color: #339966\">\/\/ Microsoft provides programming examples for illustration only, without warranty<\/span>\n<span style=\"color: #339966\">\/\/ either expressed or implied, including, but not limited to,<\/span>\n<span style=\"color: #339966\">\/\/ the implied warranties of merchantability or fitness for a particular purpose.<\/span>\n<span style=\"color: #339966\">\/\/ This mail message assumes that you are familiar with the programming language that<\/span>\n<span style=\"color: #339966\">\/\/ is being demonstrated and the tools that are used to create and debug procedures.<\/span>\n<span style=\"color: #339966\">\/\/<\/span>\n<span style=\"color: #339966\">\/\/ This source code is freeware and is provided on an \"as is\" basis without warranties of any kind,<\/span>\n<span style=\"color: #339966\">\/\/ whether express or implied, including without limitation warranties that the code is \n\/\/ free of defect, <\/span><span style=\"color: #339966\">fit for a particular purpose or non-infringing. The entire risk as to the \n\/\/ quality and performance of <\/span><span style=\"color: #339966\">the code is with the end user.<\/span>\n<\/pre>\n<p><span style=\"background-color: #00ffff\"><strong>A.<\/strong><\/span> Download the <strong>64-bit version of Microsoft Access Database Engine 2010 Redistributable<\/strong>:<\/p>\n<p><a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=13255\">http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=13255<\/a><\/p>\n<p><span style=\"background-color: #00ffff\"><strong>B.<\/strong><\/span> Copy the <strong>installer&nbsp;<\/strong>to a <strong>local folder <\/strong>and<strong> run the install from command line<\/strong> using the <strong>\/passive<\/strong> parameter:<\/p>\n<p><strong>C:\\MSFT\\AccessDatabaseEngine_x64.exe \/passive<\/strong><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20763\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S1.jpg\" alt=\"S1\" width=\"732\" height=\"420\"><\/a><\/p>\n<p><span style=\"background-color: #00ffff\"><strong>C.<\/strong><\/span> <strong>Backup the registry<\/strong> and rename the key <strong>mso.dll<\/strong> in the following location:<\/p>\n<p><span style=\"color: #ff0000\"><strong>Warning:<\/strong> <\/span>Incorrectly editing the registry may severely damage your system. At the very least, you should back up any valued data on the computer before making changes to the registry.<\/p>\n<p><strong>HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Office\\14.0\\Common\\FilesPaths<\/strong><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20773\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S2.jpg\" alt=\"S2\" width=\"991\" height=\"334\"><\/a><\/p>\n<p><span style=\"background-color: #00ffff\"><strong>D.<\/strong><\/span> In <strong>Windows<\/strong>, create a <strong>64-bit ODBC data source<\/strong> pointing to the <strong>Excel file<\/strong> to be imported:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S3a.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20833\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S3a.jpg\" alt=\"S3a\" width=\"1198\" height=\"595\"><\/a><\/p>\n<p><span style=\"background-color: #00ffff\"><strong>E.<\/strong><\/span> In <strong>AX<\/strong>, create an <strong>ODBC source data format<\/strong> using <strong>the 64-bit ODBC data source<\/strong> created before:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S3b.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20824\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S3b.jpg\" alt=\"S3b\" width=\"1493\" height=\"362\"><\/a><\/p>\n<p><span style=\"background-color: #00ffff\"><strong>F.<\/strong><\/span> In <strong>AX<\/strong>, create a <strong>Processing group<\/strong> using the source data format just created. The query should look like: select * from [worksheet$], for example:<\/p>\n<p><strong>Select * from [S1$]<\/strong><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20791\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S5.jpg\" alt=\"S5\" width=\"1156\" height=\"743\"><\/a><\/p>\n<p><span style=\"background-color: #00ffff\"><strong>G.<\/strong><\/span> In <strong>AX<\/strong>, generate the mapping and <strong>test:<\/strong><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S4.jpg\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20782\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S4.jpg\" alt=\"S4\" width=\"1155\" height=\"607\"><\/strong><\/a><\/p>\n<p><span style=\"background-color: #ffff00\"><strong>3. Run the DIXF Excel file \/ ODBC source data format&nbsp;import as a Batch<br \/>\n<\/strong><\/span><br \/>\nWe can now proceed and <strong><span style=\"color: #339966\">run<\/span> the DIXF import<\/strong> using <strong>Batch processing<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S6.jpg\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20801\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S6.jpg\" alt=\"S6\" width=\"863\" height=\"757\"><\/strong><\/a><\/p>\n<p>The Batch job is <strong>executing<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S7.jpg\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20811\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S7.jpg\" alt=\"S7\" width=\"1192\" height=\"404\"><\/strong><\/a><\/p>\n<p>The Batch job has <strong>ended <span style=\"color: #339966\">successfully<\/span><\/strong>:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S8.jpg\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20821\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S8.jpg\" alt=\"S8\" width=\"1192\" height=\"315\"><\/strong><\/a><\/p>\n<p>We can <strong>verify<\/strong> that the job ran as expected by checking the <strong>Execution history<\/strong>, too:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S9.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20823\" src=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S9.jpg\" alt=\"S9\" width=\"1063\" height=\"663\"><\/a><\/p>\n<p><span style=\"background-color: #ffff00\"><strong>4. Testing<\/strong><\/span><\/p>\n<p>As always, ensure you\u2019ve set up a proper <strong>Dynamics AX <\/strong><span style=\"color: #ff0000\"><strong>TEST<\/strong><\/span><strong> environment <\/strong>first, and that you are familiar with the impact of your <strong>DIXF actions<\/strong> before you perform them in <span style=\"color: #800080\"><strong>PROD<\/strong>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Consider a scenario where you are running AX 2012 R3 and you want to import data from Excel files using ODBC. Having recently worked a case on this topic, I thought I\u2019d share some of the details on how this can be set up. 1. Background The main reason we were looking into this way<\/p>\n","protected":false},"author":4426,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"link","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[18],"topic":[4908],"audience-type":[],"audience":[4684],"ms-author":[],"coauthors":[7699],"class_list":["post-20753","post","type-post","status-publish","format-link","hentry","post_format-post-format-link","content-type-thought-leadership","topic-data-management","audience-business-leader","review-flag-1593580359-656","review-flag-1593580425-950","review-flag-1593580768-560","review-flag-2-1593580434-938","review-flag-3-1593580439-147","review-flag-4-1593580444-193","review-flag-alway-1593580307-456","review-flag-free-1593619511-304","review-flag-vm-1593580803-894"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>DIXF - Importing data using Excel and ODBC - Microsoft Dynamics 365 Blog<\/title>\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.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DIXF - Importing data using Excel and ODBC - Microsoft Dynamics 365 Blog\" \/>\n<meta property=\"og:description\" content=\"Consider a scenario where you are running AX 2012 R3 and you want to import data from Excel files using ODBC. Having recently worked a case on this topic, I thought I\u2019d share some of the details on how this can be set up. 1. Background The main reason we were looking into this way\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Dynamics 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-08T14:24:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-05T19:18:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png\" \/>\n<meta name=\"author\" content=\"Claes Norell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Claes Norell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/author\/claes-norell\/\",\"@type\":\"Person\",\"@name\":\"Claes Norell\"}],\"headline\":\"DIXF &#8211; Importing data using Excel and ODBC\",\"datePublished\":\"2016-04-08T14:24:52+00:00\",\"dateModified\":\"2023-07-05T19:18:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/\"},\"wordCount\":483,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/\",\"name\":\"DIXF - Importing data using Excel and ODBC - Microsoft Dynamics 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png\",\"datePublished\":\"2016-04-08T14:24:52+00:00\",\"dateModified\":\"2023-07-05T19:18:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DIXF &#8211; Importing data using Excel and ODBC\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/\",\"name\":\"Microsoft Dynamics 365 Blog\",\"description\":\"Modernizing Business Process with Cloud and AI\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization\",\"name\":\"Dynamics 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Dynamics 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DIXF - Importing data using Excel and ODBC - Microsoft Dynamics 365 Blog","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.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/","og_locale":"en_US","og_type":"article","og_title":"DIXF - Importing data using Excel and ODBC - Microsoft Dynamics 365 Blog","og_description":"Consider a scenario where you are running AX 2012 R3 and you want to import data from Excel files using ODBC. Having recently worked a case on this topic, I thought I\u2019d share some of the details on how this can be set up. 1. Background The main reason we were looking into this way","og_url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/","og_site_name":"Microsoft Dynamics 365 Blog","article_published_time":"2016-04-08T14:24:52+00:00","article_modified_time":"2023-07-05T19:18:07+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png","type":"","width":"","height":""}],"author":"Claes Norell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Claes Norell","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/author\/claes-norell\/","@type":"Person","@name":"Claes Norell"}],"headline":"DIXF &#8211; Importing data using Excel and ODBC","datePublished":"2016-04-08T14:24:52+00:00","dateModified":"2023-07-05T19:18:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/"},"wordCount":483,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/","name":"DIXF - Importing data using Excel and ODBC - Microsoft Dynamics 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png","datePublished":"2016-04-08T14:24:52+00:00","dateModified":"2023-07-05T19:18:07+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2016\/04\/S01.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/04\/08\/dixf-importing-data-using-excel-and-odbc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/"},{"@type":"ListItem","position":2,"name":"DIXF &#8211; Importing data using Excel and ODBC"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/","name":"Microsoft Dynamics 365 Blog","description":"Modernizing Business Process with Cloud and AI","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#organization","name":"Dynamics 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Dynamics 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/#\/schema\/logo\/image\/"}}]}},"word_count":583,"msxcm_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Dynamics 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/posts\/20753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/users\/4426"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/comments?post=20753"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/posts\/20753\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/media?parent=20753"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/post_tag?post=20753"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/product?post=20753"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/content-type?post=20753"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/topic?post=20753"},{"taxonomy":"audience-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/audience-type?post=20753"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/audience?post=20753"},{"taxonomy":"ms-author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/ms-author?post=20753"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/wp-json\/wp\/v2\/coauthors?post=20753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}