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