ODBC Connection, Microsoft Excel, Micro Focus UFT, HP QTP
In this video I showed how to bring data from MS Excel to UFT or QTP using ODBC Connection.
Language: VBScripting
Tools: HP QTP, Micro Focus UFT, Microsoft Excel
Author: md shahajada imran
Step 1: Create “dsn” in ODBC.
Step 2: write UFT Script.
a. Create parameters for ODBC connection.
b. Create connection object, recordset object.
c. Find out the rows count in the recordset object.
d. Find out columns count in the Recordset object.
e. Move data from Recordset object into Runtime DataTable.