0tacon
asked on
Populate combo-box from ODBC in Excel?
Experts,
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
Many thanks
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
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.