Creating a macro that returns results of a SQL query

[jrosen12]

Hello,

I am new to VBA and I am looking to create a macro that connects to database "REPT" and returns distinct values for columns "sub_id" and "term_date" where the value in "plan_code" column is "444"

 

[Joe4]

Have a look here: https://smallbusiness.chron.com/use-sql-statements-ms-excel-41193.html