Excel Query Statement Amendment

[mattpope697]

Dear All,

I need to amend the SQL statement code within my query but it's greyed out and unable to make any changes, see below:

For security reasons I have removed the server address and database name. I am obviously doing something wrong or have incorrect settings but does anyone know how I can rectify this issue, un-grey the SQL statement, and amend the code?

Many thanks in advance.

Matt

 

[rpaulson]

Matt,

I tried for day to get the method you show to work for me. It was a pain in the A**.
not sure if you are willing to try VBA, if you are watch this video, its amazing!!