Excel inserting records to SQL Help

Hey guys

I hope your well

I need some help,

Aim -
My SQl query produces the following 6 columns (Column B-G) on Sheet1. I want the relevant department to update column E with a unique code, Once the department made the necessary changes , press a button (Which be called “Update”) when the button is pressed, it automatically Inserts the new records to the relevant table in SQL

My SQl Query which produces (Column B-G) is on a tab called "query"

The SQl table i need updating is called "[FDMS].[dbo].[Master_RM_Account_List]"

Sql table [Master_RM_Account_List]
fields
,[MerchantID]
,[RMID]

ParentID (Sheet 1) mapped to MerchantID
RM_Account (Sheet 1) mapped to RMID

server=w4pvdb999;
database=FDMS;
trusted_connection=true

I have attached the excel document,

Looking forward to your response

Regards
D