Tech Support > Microsoft Windows > Windows CRM > Problem importing leads/contacts with embedded comma in fields
Problem importing leads/contacts with embedded comma in fields
Posted by Robert Morris on April 28th, 2005


When importing .csv file, if a text field that is delimited with double
quotes contains a comma the import tool still see the comman and separated
the field into two or more fields, which then shifts all the following fields
into the wrong position.

Am I missing a fix. I am running CRM 1.2 with the last rollup. Was there an
earilier patch to fix this.
Thanks - Bob

Posted by John O'Donnell on April 30th, 2005


There is no fix. You have to ensure your CSV data is clean.

--
John O'Donnell
Microsoft CRM MVP
http://www.mscrmfaq.us


"Robert Morris" <RobertMorris@discussions.microsoft.com> wrote in message
news:7EBD580D-E320-4CCC-8F0B-BF40B475940E@microsoft.com...



Similar Posts