Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Import Account failed

(0) ShareShare
ReportReport
Posted on by 40

Hey Team!

Im trying to export contacts and accounts from one CRM environment to a new one.

Both environments are the latest dynamics CRM.

But when I try to import the excel files in the new enviorment i get this error message.

Can someone explain what could be wrong?

fail-migration2.png

Mvh

Tomas

*This post is locked for comments

  • Suggested answer
    Arun Vinoth Profile Picture
    Arun Vinoth 11,613 on at
    RE: Import Account failed

    We don't want always the exported file to be in re-import compatible mode. This was a easy step earlier, but not anymore.

    www.powerobjects.com/.../mass-editing-dynamics-crm-2011-records-using-microsoft-excel

    So you have to manually remove those columns like David explained or copy the content & save in a new file to keep the backup & cleaner way.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Import Account failed

    When you export data from CRM to Excel, CRM adds 3 hidden columns (columns A, B and C) to the spreadsheet. These are used to allow you to import the data into the same organisation, allowing updates to existing records. However, these columns are the cause of the error above, as this process is not designed to work across organisations. You should be able to unhide and delete the columns from the Excel sheet, then import the data into a different organisation

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans