Exception from HRESULT: 0xC004802-Data Import/Export Framework AX 2012 R3

11 May

I have been trying to import data from an Excel file using Data Import Export Framework. The mapping and validation works but when I try to import the data into staging table – I get the below error:

Exception from HRESULT: 0xC0048021

I am using Dynamics AX 2012 R3 RTM with Excel 2013 64 bit.So before going in to solution please install 64-bit Microsoft Excel Driver on 64-bit machine (OS) with ‘Microsoft Access Database Engine 2010 Redistribute’ (AccessDatabaseEngine_x64.msi) by using “/passive” argument.

Let’s review the Problem statement and Solution in details

Problem Statement.

First off I’ll be using Source data format of Type = Excel to import the data from Excel file

Source data format

Please note that Source data format Type = “File” and File format = “Excel”.To begin with I’m going to use standard DIXF “Vendor” Target entity and I’ll introduce a processing group

Processing group


Then I selected Source file and I’ll use “Generate source mapping” option


I found entity mapping is done successfully.


Now Select entities for processing group – Preview file contents. you will get below error.



AX Version: Microsoft Dynamics AX 2012 R3 RTM
Microsoft Office: Office 2013, Excel 2013
OS: Windows Server 2012
SQL: SQL 2014
If you’re using Excel 2013 32 bit or 64 bit , the problem is caused by DMConfig XML file.

Go to the DMConfig.xml file in the “C:\Program Files\Microsoft Dynamics AX\60\DataImportExportFramework” folder and replace the PipelineComponentInfo_Multicast, PipelineComponentInfo_ExcelSource and  <PipelineComponentInfo_ExcelDestination> nodes by the following:


That solved the issue for me!

if above tags value does not work then try below lines


Leave a comment

Posted by on May 11, 2015 in Uncategorized


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: