ms-accessvbagetstring

Selecting particular columns in ADO using getstring

When we use getstring to get data from a recordset (ADO) then it returns all the columns.

If only certain columns are required, how do we modify the getstring statement?

Solution

  • You can take a step back and build the recordset with only the fields (columns) that you want, for example:

    strSQL="SELECT ID, FName, SName FROM Members"
rs.Open strSQL, cn

a=rs.GetString