0
Answer

Data transfer from excel to sqlserver using linked server

Dhilip Kannan

Dhilip Kannan

11y
900
1
Dear all,
   i created link between sql server and excel file using linked server .the data is transfered from excel to sql server .thats working fine.Consider previously 3 rows are been in excel file.

  when i insert a new row in sqlserver what happens the new row is added and also the previous 3 rows is again repeated like 3+3 +1 (new row).how to avoid this repeated row.below is the query i used.

insert into queryexcel...Sheet1$(PersonNumber,LastName,Firstname,ThirdName,CardNumber)select * from dbo.tbl_emp1


Please give me some idea.

Thanks,
Dhilip