The simplest way I can think of is to load the data from the Excel file into a Work Table and then write a query to Add/modify/delete. To delete the following, and similar code for Insertions and updatesDELETE y
FROM YourRealTable y
WHERE EXISTS
(
SELECT * FROM YourWorkTable w
WHERE w.customerid = y.customerid
AND w.status = 'Delete'
);
You can use SSIS to insert and to run the update queries.
Insert rows
Posted - 12/11/2012 : 16:35:51
