• A double quote is not the same as two single quotes.

    A double quote is one character, so I don't think it was there to escape a single quote.

    The error probably comes from the fact you have an opening double quote but no closing double quote, since the double quote is the text delimiter.

    This is an error in the file and you should contact the provider.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP