How to read expected row from MsAccess table in QTP

[dineshb]

Hi,
The solution is as below.

Code:

set con = CreateObject("ADODB.Connection")       'Create MsAccess object
set rs =CreateObject("ADODB.recordset")               ' record set
con.provider = "microsoft.jet.oledb.4.0"
Sql = "Select City from Address"  'consider 5 records in table Address
rs.open Sql,con
' moves the control to 2nd record/row by following statement
rs.move(2)

Thanks
Dinesh