I’m currently facing an issue with the import functionality. I’m using the attached store procedure to import data from a comma-separated file. However, the import fails when the file contains fields that include commas within the data.

For example, please refer to the Surname column in the People DOB file, which has values like “Bob,Maggio”. The presence of the comma within the quoted string seems to be causing the import to break, resulting in the following error: 

Error : “Conversion failed when converting date and/or time from character string.”

It seems the import logic is not handling such cases when commas are part of the field values. Could any one assist me in resolving this issue or suggest the best way to handle such data during import?

Thank you!