Months later, after struggling with the same task, I've managed to load it!
Replace all double-double-quotes ("") within the values in the file by something harmless (i.e.
'). Orange then manages to load it.
The comment by "CodesInChaos" did indeed point in the right direction:
This is a bug (in Orange or some library it uses) in parsing the quoted values. To be specific, it does not correctly handle correctly escaped double quotes inside the values of the columns.
RFC 4180 says:
If double-quotes are used to enclose fields, then a double-quote
appearing inside a field must be escaped by preceding it with
another double quote.
However, occurrence of this kind of escaping in the file causes the observed error in the Orange.
NOTE: Careful, simple search & replace may not cut it in general case - if the value itself starts with the double-quote, you would replace """ with '", which would produce invalid csv.
Also of NOTE: Weka seems to have this limitation too. Additionally, it does not tolerate line-breaks inside the quoted values - which again, according to the RFC are valid.
Moral of the story: CSV parsing is not easy.