ExcelBanter - Excel RTD,SQL Server and persisting range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel RTD,SQL Server and persisting range (https://www.excelbanter.com/excel-programming/402455-excel-rtd-sql-server-persisting-range.html)

axwack

Excel RTD,SQL Server and persisting range

I have a requirement where I will be sending data fed via Excel RTD.
The data that is sent over will be persisted to SQL Server every 1
second.

What is the best way to send a set of ranges to the database and
insert them into a table?

All times are GMT +1. The time now is 05:27 PM.