Thx Leith.
I solved by looking mostly through forum and playing around with the recommendations.
Long story short. I first figured out how to link Excel to the database. Then how to pull the record set.
I also had a problem where I copied the SQL from Access into VBA Excel and it took me some time to notice that the table names in Access had a format of ABC_TABLE_NAME, where in reality ABC was the server so the name in the Excel SQL was ABC.TABLE_NAME.
Tested and working OK now.
If it helps anyone here is the code (The SQL statement is in Sheet(2)):
Bookmarks