EXCEL CRUD (CREATE/READ/UPDATE/DELETE) MSSQL

[kunteX]

Please suggest/guide me where I can get template/step by step document / blog/ video any one for following

Need to insert/update/delete MSSQL table through EXCEL. 

for e.g. 

DimColor table in MS SQL, user can insert/update/delete through Excel. 

May be through VBA or calling Store Procedure. 

Thanking you in advance.

[#2]

You can do literally any web search on it and find everything you need. Search for: "excel vba connect sql". If you want to see how to call stored procedures from VBA, search for: "excel vba connect sql stored procedure". Basically it comes down to 1) connect to the db, 2) call your method.

While I don't know what you want to do, if you're wanting to perform CRUD-like actions within Excel, the logic would presumably reside in VBA, but generally this should reside in your queries and stored procedures in SQL Server and you would just call them from Excel, which is the recommended method.