../../../../2020/03/updating-sql-tables-from-excel/ XLCubed Blog Tue, 12 Jan 2021 14:17:30 +0000 hourly 1 https://wordpress.org/?v=5.3.21 ../../../../2020/03/updating-sql-tables-from-excel/#comment-140389 Tue, 12 Jan 2021 14:17:30 +0000 https://blog.xlcubed.com/?p=5896#comment-140389 Thank you for that information.
I can’t find the formula XL3RunArea but I can see XL3SqlArea. @XLCubed, maybe something for the next blog article.

]]> ../../../../2020/03/updating-sql-tables-from-excel/#comment-65721 Fri, 20 Mar 2020 18:07:42 +0000 https://blog.xlcubed.com/?p=5896#comment-65721 Hi, very interesting article. there is nevertheless an even more powerful XL3RunArea function which is very poorly documented but which allows you to go much further in data management (update,insert records) with Sql Server. this function doesn’t validate line by line like XL3RunSQL but only one trigger allows you to validate all the records. it is therefore possible to update very large tables, which is not really appropriate with XL3RunSQL. in addition this function XL3RunArea works with the pager which allows to display a precise number of records on the screen while having the possibility to go forward or backward in the records of the table.

]]>