I have a temporary table that contains several fields. But I want to add records to a separate table named tblVendors using just 10 of the fields in the temporary table. The code will have to loop through the records in the temporary table and insert a new record into tblVendors BUT ONLY if the same combination of field data does not already exist. What would this VBA code look like?
In other words if any one field is different that a record already in tblVendors, go ahead and create the new record. But if all 10 of them are an exact match, do not create the new record