'SQL Update query via VBA using ODBC connection
I have an ODBC connection to a database set up in Control Panel using a DSN. I can use this to see data from tables and Views in Excel. What I need to be able to do next is connect to that same data set and run an SQL update query via button. Any help would be greatly appreciated.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|