Forum Discussion
EXCEL CRUD (CREATE/READ/UPDATE/DELETE) MSSQL
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 tabl...
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.
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.