Hello,
I'm trying to export a large set of data from CRM so that I can edit some information and then re-import that data. I'm running into an error every time I try to re-import the file though. I go through the process of exporting, selecting the option to "make this data available for re-importing by including required column headings", and saving the file as an XML Spreadsheet 2003. I then make my changes, save the file again (locally), and then try to upload, but I'm getting an error message that says "The file that you uploaded is invalid and cannot be used for updating records." I'm not making any changes to the file type after I've made my changes (still an XML Spreadsheet 2003).
I've been doing lots of testing and reading online, and I found that if I manually enter the changes to the data, the import succeeds. When I try to copy the data in from another spreadsheet, the import fails. I can't manually edit each record, because there is too many, and I'd like to copy the updated information from another sheet. I'm making sure that the data type for the content I copy over is the same (Text), but it's still failing.
Has anyone else experienced this problem, or know of a solution? The Microsoft support guy I worked with couldn't give me an answer.
Thanks in advance,
Anthony
*This post is locked for comments
I have the same question (0)
