WHERE IN Query with two recordsets in Access VBA
- by Henry Owens
Hi All,
My first post here, so i hope this is the right area. I am currently trying to compare 2 recordsets, one of which has come from an Excel named range, and the other from a table in the Access database. The code for each is:
Set existingUserIDs = db.OpenRecordset("SELECT Username FROM UserData")
Set IDsToImport =…