You could pass in an SQL statement to do that.

Something like:

SQL = "SELECT Field1,Field3,Field6 FROM MyDB"

rst.open SQL, cnn, 2, 2

This would create a recordset with those particular fields where 'Field1 etc.' is your column names and and 'MyDB' is the name of your DB.