Open a query

Microsoft Query

Show All

Open a query

  1. Click Open Query , click the query file you want to open, and then click Open.

    A query file has a .dqy or .qry file name extension.

  2. If prompted, enter your logon name, password, and any other information required for your data source.
  3. If prompted, enter parameter values for the query, and then click OK. If you do not know what the valid parameters are, contact the person who created the query.

Note   You can also open an .oqy cube definition file that was created by using the OLAP Cube Wizard. Opening this type of file starts the wizard so that you can change the cube definition. Learn about creating cubes by using the OLAP Cube Wizard.