Correct syntax for embedded commas, and then embedded double-quotes, is:
but not all CSV import routines honour that complete syntax, in which case you are hosed. Change the embedded commas to something else (which is a right-royal-pain to implement on every single column, of every single table, that you export.
Use XML instead. Problem solved.
Better still, use direct database-to-database connection instead, and then things like DATES don't get "formatted" on Export and then "parsed" on Import, with all the nightmare of dd/mm/yy and mm/dd/yy etc. that that entails.
Either way, CSV should have died a death bacjk in the 70's, but sadly it still hasn't done.
Chinese Characters anyone? Line Break in the data?