Simple macro that shows how to open connection to ms sql database, how to create table, insert records, update records, delete records and delete table
More info with ready to copy and paste code: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2014/12/excel-macro-mssql-simple-crud-example.html