locked
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?

    Thanks

    Andrew

    Wednesday, September 23, 2020 8:24 PM

Answers