Updating or adding to a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if it is possible and how to just add one field to a record
when importing from an excel file instead of importing the whole reocrd?
Example, we have a contact database and everyone needs to have an e-mail
address and I want to know if i can just import that field into specific
records. Thanks for any responses in advance.
 
An Update query, based on an Inner Join should do the trick.

Update TableA set a.fieldname = b.fieldname
From
Select fieldname from TableB inner join table a on a.id = b.id

or something similar.
 
Back
Top