Import data using Microsoft Query

Relevant for: GUI tests and scripted GUI components

You can use Microsoft Query to choose a data source and define a query within the data source.

  1. Open the Database Query Wizard and select Create query using Microsoft Query.

  2. When Microsoft Query opens, choose a new or an existing data source.

  3. Define a query.

  4. In the Finish screen of the Query Wizard, select one of the following:

    • Exit and return to UFT One > Finish to exit Microsoft Query.

    • View data or edit query in Microsoft Query > Finish to view the data.

    After viewing or editing the data, select File > Exit and return to UFT One to close Microsoft Query and return to UFT One.