SQL Server 2017 - Import csv data into existing table ignoring 1st data row RRS feed

  • Question

  • Hi, I have a csv file that has the value "sep=," in the first row and the header in the second row.

    I can import it as using the flat file wizard however that doesn't allow importing into an existing table.

    The data import task allows importing into an existing tables but i can't figure out which options to change so that it ignores 1st row, takes header from second row and then data in following columns.

    Any ideas?



    Wednesday, September 23, 2020 8:24 PM