Excel VBA to extract data from Access field based on criteria

[msquared99]

OK, I have a macro I am working on, it will be pulling data from an Access DB Query. What I am trying to figure out is the Access Query has a column for each month. I want to be able to select the month I want VBA to pull into my spreadsheet. Much like checking or unchecking the Show box in the Access query.

So in the Access Query I have a field name of Jan, another of Feb, and so on for each month. Can I use VBA in Excel to pull in only the field name of the month I choose?

Make sense?

 

[msquared99]

OK, I found some code but I get this, "Syntax error (missing operator in query expression 'Start Date'.

Referencing this code line:

rs.Open SQL, con&

Here is the line of code referencing the table names:

SQL = "SELECT 2015, Service, Start Date, First Year Comm %, Residual Commission FROM " & strTable&[code]