We have some data in a CSV file to import into CRM.
Some rows will be for contacts and companies which do not already exist in our CRM, and can be imported fine.
Others will be an update to existing CRM contacts/companies. If we import as leads, we could convert to create duplicate records and then merge them. There are lots so that would be slow and painful!
Is there a better way to update existing records?
I have seen something about using powershell, but I don't know if it will work for CRM 4?