title: Create an Update Query using Union Function?
body: <p>I have an Excel table that I import to an Access 2010 database table. The only problem is the data for one field (Health Plan) is not consistent with what we currently use in our database. For example the data that is being imported shows "GA" vs what it should be, "CHC - GEORGIA". I'm able to make a simple Update query for changing ONE at a time, but I have 15+ states that need to be changed. This is what I was shooting for in combining these into one query:</p>
  
  <pre><code>UPDATE [Dan - CSF Quotes] SET [Dan - CSF Quotes].[Health Plan] = "HEALTHAMERICA And HEALTHASSURANCE"
  WHERE ((([Dan - CSF Quotes].[Health Plan])="PA"))
  
  UNION 
  
  UPDATE [Dan - CSF Quotes] SET [Dan - CSF Quotes].[Health Plan] = "CHC - GEORGIA"
  WHERE ((([Dan - CSF Quotes].[Health Plan])="GA"));
  
  .
  .
  .
  etc
  </code></pre>
  
  <p>Is there any easy way to change/update the values to this one field?</p>