The easiest thing you can do is create the query in your database and copy the sql from the query and add it to your code.
Then you can do something like this below, Makes it alot faster then looping thru the recordset

Range("A2").CopyFromRecordSet rs