Import SQL VIEW To excel with VBA

I am having a problem getting the View of severel tables from the server.
I do not normaly work with SQL, so bare with me, and spell it out loud and clear :-)

I have a test Workbook with the code.

I hope someone kan help.
My code works fine when just getting tables, but here I need a combination of some tables and have learned that that is a VIEW.