Perform this procedure to run a query after its data connection is configured.
To run a query using an existing ODBC data connection
-
In Excel, select a cell in an open worksheet and click Data > Existing Connections. The Existing Connections window opens.
On the Connections tab, under Connection files on this computer, select the connection to the query you want to run.
Note: Each connection corresponds to a single query and a specific repository.Click Open. The Import Data window opens.
(Optional) To modify the query:
Click Properties to open the Connection Properties window.
Click the Definitions tab and make changes as necessary to the query syntax in the Command text field.
Click OK to save the settings and close the window.
To run the query and import data, in the Import Data window click OK. If prompted, enter your password to log on to the data source.