To retrieve data into the worksheet in Query Designer:
Select one of the worksheets in the navigation panel; for example, Query1.
Right-click and select Retrieve.
The worksheet displays the results of the data retrieval.
Notes:
To retrieve data in all worksheets, select the worksheet node in the navigation panel. Right-click and select Retrieve All Worksheets.
This task performs the same function as selecting the Retrieve command in Spreadsheet Add-in.
To retrieve data into the worksheet in Query Designer: