title: What is the best way to transfer excel row from on change named range to sql server db?
body: <p>I have a dynamic excel sheet that's connected to stock market prices. From a named range in this sheet, I want to trigger any row change to export selected columns as a new record in a database table.</p>
  
  <p>This will be out for a lot of excel rows data changes that are to be inserted into a database table. </p>
  
  <ol>
  <li>What is best Technique for a robust and reliable connection?</li>
  <li>Any examples or tutorials for on change row exports to sql?</li>
  </ol>