-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules