Check if value exists in Sql server Table with vba
I need some help in completing one of my activity which requires Excel vba and SQL server tables...
SQL server Table ->
1) Maintain_Table-->Which consists of only one values that is 0 or 1.
1) On Excel sheet will have a button "click here".
2) When user clicks on the button should first check if Maintain_Table has a value 0 or 1 and show popup message accordingly.
So finally need a code which can connect to SQL server and connect to table and check if value exisits.
Thanks for the help in Advance!