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?