Jean-Christophe Cabot – XLCubed Blog ../../../ XLCubed Blog Thu, 11 Nov 2021 11:17:07 +0000 en-GB hourly 1 https://wordpress.org/?v=5.3.21 ../../../wp-content/uploads/2016/09/cropped-logo_512_512-150x150.png Jean-Christophe Cabot – XLCubed Blog ../../../ 32 32 Updating SQL Tables from Excel: A New Approach (Part 2) ../../../2021/11/updating-sql-tables-from-excel-a-new-approach-part-2/ ../../../2021/11/updating-sql-tables-from-excel-a-new-approach-part-2/#respond Thu, 11 Nov 2021 11:16:15 +0000 https://blog.xlcubed.com/?p=6415 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. Part 2: Tracking Changes and Updating the SQL Table Tracking the changed rows We need a way to track what […]

The post Updating SQL Tables from Excel: A New Approach (Part 2) appeared first on XLCubed Blog.

]]> ../../../2021/11/updating-sql-tables-from-excel-a-new-approach-part-2/feed/ 0 Updating SQL Tables from Excel: A New Approach (Part 1) ../../../2021/11/updating-sql-tables-from-excel-a-new-approach-part-1/ ../../../2021/11/updating-sql-tables-from-excel-a-new-approach-part-1/#respond Thu, 11 Nov 2021 11:15:00 +0000 https://blog.xlcubed.com/?p=6399 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 […]

The post Updating SQL Tables from Excel: A New Approach (Part 1) appeared first on XLCubed Blog.

]]> ../../../2021/11/updating-sql-tables-from-excel-a-new-approach-part-1/feed/ 0