Quick way to update records

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

I have 2000 records and I need to update 300 of them by simply adding yes to
a field value. I have a list of email addresses for the record in excel. I
tried to do a match query by making another table using the email list from
excel and matching them to my current contact table, but when I do that the
recordset is not updateable. So I have them all there just like I need, but
can't change the field I need to to "yes". What is a better way to go about
this process? Thanks for the help.
 
Back
Top