>>Our client(s) is send us CSV files with demographics of people they serve. The problem is that a few of the rows in the CSV have names and/or addresses with embedded comma in them. This is throwing the APPEND a problem. The wrong data is ending up in the wrong columns.
>>Can anyone suggest how to prevent this from happen at my end.
>
>Perhaps you should process such files line by line?

Yes, I have considered that. But there are 10s of thousands of rows, and several files of them. The performance hit would be great.