This article has been archived. It is offered "as is" and will no longer be updated.
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.
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
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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