Hiya,
When I connected to another worksheet to access its data using Get data -> From File -> From workbook and loaded the table, I get the table, however I am unable to edit the sql code in the Connection properties -> Definition.
Pretty much everything is greyed out in there.
I would like to select certain columns, join other tables and things liek that by editing the code in the Command text field.
I am sure I was able to do that a while ago using the same connection, though I am not sure what version of Excel I was using.
Anyone has any suggestions?
I'm mainly want to practice SQL coding, with a few example talbes to pull data from.
Capture.PNG
Thank you
Bookmarks