I am trying to import CSV data containing chunks of text. I find CSV import easily confused when text contains ' or " or a mix of them. It seems like Toad does not escape those things correctly when forming SQL.
The CSV file is valid and properly escaped. It can be opened in Excel just fine.
I tried both 4.6 and 5.0 beta with the same results.