Hi,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.Is that a known issue?Thanks,Dima.
If you are running MySQL on a Windows machine you could try the "mysqlimport.exe" command.You can start this also from Toad, but is more robust than the Toad import tool.