add excel file as a linked server,

then

INSERT INTO A_Table

SELECT c1, c2 ...

FROM LinkedExcelName...Sheet1$

WHERE something