Import SQL server Import Excel

Question

Dear Engineers 

 

I greet you all of you after that i have a problem when i try to import sql serve from excel sheets he added but is duplicate and is not match 

 

Please resolve 

 

the below code i am using 

 

Bulk INSERT TEST

FROM 'C:\Users\Abdirahman\Desktop\TEST.txt'

with (DATAFILETYPE='CHAR',FIELDTERMINATOR=',',ROWTERMINATOR='\N');

 

and the output is record we look like this below 

 

11100 maxamed yusuf,

33333, ali ahmed maxamed

11100 maxamed yusuf,

33333, ali ahmed maxamed