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 OpenText Functional Testing.