samuelimtech
04-20-2017, 02:20 AM
hi all,
firstly thank you for any help.
i have some code that converts an array into a recordset so i can work with the data a little better.
the problem i have is i cant find an example of how to manipulate a recordset that already exists within memory, all the examples are essentially creating a connection to a database and then reading including the SQL.
so in summary I have a record set stored in excel vba, Can someone please provide an example of a select query with a where clause ("WHERE Field1 = 123") on the recordset (rs)
cheerz
firstly thank you for any help.
i have some code that converts an array into a recordset so i can work with the data a little better.
the problem i have is i cant find an example of how to manipulate a recordset that already exists within memory, all the examples are essentially creating a connection to a database and then reading including the SQL.
so in summary I have a record set stored in excel vba, Can someone please provide an example of a select query with a where clause ("WHERE Field1 = 123") on the recordset (rs)
cheerz