Home Forums SQL Server 7,2000 T-SQL BULK INSERT & Text Qualifier RE: BULK INSERT & Text Qualifier

  • January 18, 2008 at 7:05 pm

    #769917

    Sergiy (1/14/2008)

    All of you are wrong.

    Using "," as delimites is an error waiting to happen.

    mdjtlj, ask you supplier to build a test file containing '19" Monitor'.

    Then try to process that file.

    Works fine if BCP format file is properly constructed. Delimiter of "," (including the quotes) is perfect for "real" CSV instead of "comedy separated values".

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)