Home Forums SQL Server 2008 T-SQL (SS2K8) Bulk insert with format file - handling quotation mark text qualifiers in header row RE: Bulk insert with format file - handling quotation mark text qualifiers in header row

  • August 5, 2016 at 8:00 am

    #1894057

    Hi Jeff,

    I am facing difficulty when column row is not having any text qualifier but data rows have.

    what would be the format file structure in this case.

    --Data file structure

    Column1Name,Column2Name,Column3Name

    "Row2Column1Data","Row2Column2Data","Row2Column3Data"