I am using Visual Basic 6 with MS Access 2007. Here is the scenario,
i have to copy data from one database to another database. Let rs1 be the first Recordset, from where all the fields to be copied to the second recordset let rs2. There is a field ("Date") on both recordset. Now the condition is that if there already exist the data of a particular date on rs2, then it should skip the operation and goto next row and so on.
Need help doing this. Thanks in advance