Check if value exists in Sql server Table with vba

Hello Experts.

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.

Action
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!