Error message when you try to import a CSV file into Microsoft Dynamics CRM 4.0: "The source data is not in the required format"

Article translations Article translations
Article ID: 949652 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When you try to import a comma separated values (CSV) file into Microsoft Dynamics CRM 4.0, you receive the following error message:
The source data is not in the required format.
This problem occurs if the following conditions are true:
  • You create a data import map for an entity that contains lookup type fields.
  • The field mapping for the lookup type fields is not created.
  • You save the data import map as a CSV file. Then, you try to import this file into Microsoft Dynamics CRM 4.0.

Resolution

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More information

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
For more information about Microsoft Dynamics CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Properties

Article ID: 949652 - Last Review: June 21, 2014 - Revision: 5.0
Applies to
  • Microsoft Dynamics CRM 4.0
  • Microsoft Dynamics CRM Online Professional Edition
  • Microsoft Dynamics CRM Online Professional Plus
Keywords: 
kbautohotfix kbsurveynew kbHotfixServer kberrmsg kbfix kbexpertiseinter kbmbsmigrate kbqfe KB949652

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com