Import Excel data to table in SQL Server (only data other than that already in the table)

Question

I just want to add different records than the ones already in the table, that is, they would only be records from Idcollaborator 10.

Answer 1

There are some solutions and one of them involves using Linked server to access the spreadsheet in Excel as if it were a table. Then include lines that are in the spreadsheet and that are not part of the table.

Here is the sketch of the code:

-- código #1
INSERT into Colaboradores (colunas)
  SELECT P.colunas
    from planilha as P
    where not exists (SELECT * from Colaboradores as C where C.IdColaborador = P.IdColaborador);

Details in the article Bulk data import (Bulk load).

Answer 2

Use Msaccess and import excel to Msaccess. Next export Msaccess to SQL. When you already have in SQL do the validations in the database before inserting