A recent attendee at a webinar posed the question, can you change the Close & Load setting on an existing query? Here is the answer.
Most times you use just use Close & Load and you create an output table.
Other times you want to only create a connection rather than an output table and you use the Close & Load drop down and select Close & Load To.
The Import Data options are then displayed.
If you have used the standard Close & Load option and delete the sheet that contains the output table you automatically convert the query into a connection only query.
On the other hand, if you have a connection only query and want to change it to a table output query how do you do that? When you edit the query the option is greyed out.
To change the Import Data setting right-click the query in the Queries task pane and choose Load To.
This displays the Import Data options ready for you to make your changes.