How to import record from only one CSV column within a Sql server column?

0

I have a csv file with several columns "ID, ROOTNAME, DATA" and want to insert the record of a "RED_NAME" column that is inside the csv file in my sql server table named "DATA". My "DATA" table in the Sql server has several columns "ID, NAME, DESTINATION" however, I only need the record "NAME_RUA" that is in my csv to insert it into a column " NAME_RUA "from the" DATA "table of the sql server. Does anybody know how to solve this? just know that I will have to use a join to specify each record in the "DATA" TABLE

DATA TABLE HAS AS COLUMN:

-ID
-NOME_RUA
-DATA

CSV FILE HOW TO COLUMN:

-ID
-NOME_RUA
-DESTINO
    
asked by anonymous 30.10.2017 / 14:01

0 answers