How to read specific rows

[Arena]

Hi,

I am using an ADO connection to extract my data.

Is it possible to read data ROW by ROW?

I know that rs.GetRows(,,ARRAY(FieldName)) will read the desired column (field).

How can I do that for a specific Row(Record)?

Thanks!

Arena

[dineshkumar]

Arena,

You can try filter property like below.

rsRecordSet.Filter = " FirstName = 'Arena' OR FirstName = 'Rose' "
or
rsRecordSet.Filter = " LastName LIKE A* "

Kind regards,
Dinesh