atul.jadhav (1/30/2015)

---

Dear expert

I am using import/export wizard to upload excel in sql table

I have primary key in my table

and all primary key value has been change every day

i.e. I have customer wise sales data and having 10 customer and sales value (two column in table), every day sales value increase/change, and new customer also adding every day

now every day I drop this table and update table as fresh file

but while uploading excel file can I use sql code which do as follow

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.