Command text in the Connection Properties of External Data drawn from SQL

Hi,

I am hoping to alter the way in which I receive my data from SQL database. Currently, I am able to pull data directly from SQL, and this generates several different columns of data that I do not need. For example, I only need columns 1, 4, 7 but I have columns 1 through 8 of data. I am hoping to write some sort of command text in the connection properties to essentially delete these columns in that every time the data is refreshed, these columns will not appear / are not extracted to my excel file.

Any help would be greatly appreciated.

Thank you.

Hi,

I already have a SQL query that selects the data because it is not directly drawn from sql. Is there any way for me that, after that query, I create a new query that will only take the columns that I require?

Thanks a lot.

I am drawing from multiple tables in sql to generate the file in excel. What table would I use after the "FROM" command?

My first SQL query uses select function to pull data from multiple tables. How do I create another query to specify which data I want to keep?