Use Cell reference inside sql query command text - how?

Hi guys,

I already pull some data directly from database via sql query in excel, in time-to-time i need to redefine my database query but i dont want to go to the command text and edit from there manually.

I already create a drop down menu in cell J2, so is there any way I can put J2 cell reference inside the command text query?

so whenever I need to redefine my search on the database I just can choose at my drop down menu in cell J2, and the data will be updated automatically.


Refer Image

sql query - text command.jpg




Thanks
Azhan
Malaysia