Author: Jean-Christophe Cabot

In part 1 of this article, we have prepared the table for the update. In this second part, we will learn how to update the SQL table with only the rows modified by the user.

In a previous blog article, Ambika presented a neat method to update an SQL table from Excel.  This proved to be useful for many of our customers but could somewhat be painful for those wishing to update many rows. Today, an increasing number of XLCubed customers use Excel as a planning sandbox and often want to writeback a whole set of records back to the source SQL database at once.

In this article we will describe how you can writeback data to SQL and write only the changed values to the source table in one single pass by executing a stored procedure.