Dear both, in simple I want to append SQL table thru import/export wizard (from excel file) and that table having only tow column,

1) Customer Account No (Primary key/unique no.)

2) Sales Amount

now what I want,

1) if primary key exist in table update sales value (as per excel file) source file

2) if primary key does not exist then update in table as new row.

I hope I clear now,

Please go thru attachment file where I have mentioned with existing table, excel to be upload and expected result in SQL table