EXCEL VBA ADODB SQL and all other sorts of problems

[thesasman2012]

Hi Everyone.
thesasman2012 here again. Its that time of day where i've been pulled out of my comfort zone SAS 9.2 - and been tasked with some vba.

background.
A guy left work, took his code, no developer apart from me to re-write it.

the task.
A Spreadsheet which contains certain campaigns which have been run, and the details of this campaign is held on a central database, in this case lets just say [C:\Temp\TEST.mdb] in a query called [qry_PLAN]

1. The variables in the ACCESS query also exist in the spreadsheet (i think this may be as the spreadsheet as variables added to it at different times)
   
2. how to get excel to talk to access? the UNIQUE_ID in this case would be the [Campaign_Code],
   
3. from the example attached the spreadsheet has multiple campaigns and one of the requirements of the analyst is that they would like the macro to pick up the campaign code automatically and have the option to pull in ALL or ONE campaigns details (the campaign_code will ALWAYS be in column b in this case)
   
4. The variable names are in grey (i think this is the name in the access query) these will most defiantly be added to or took away as the spreadsheet grows or requirements are added. so i would some how need vba to read them to and from the query
   
5. Finally the grid would need to be populated with the results. (ignoring the subtotal ranges)
   
6. I understand this is a lot and i would really really really appreciate some help.