I have an ODBC set up which links to a mySQL database, and need to run a query which produces a single column to subsequently populate a combo box in a worksheet. I know the SQL for the query, but it's been a while since I rolled up my sleeves in VBA so any help is much appreciated!
So basically I need:
1. VBA to connect to the ODBC
2. run the Query (produces a single column- I have the SQL)
3. populate a combo box in my worksheet with the result