Access Query Question

  • Thread starter Thread starter Rae
  • Start date Start date
R

Rae

If I have a table of HomeOwners and a Table imported from an Excel
Spreadsheet that includes some of the names in the HomeOwners table,
How can I update the imported table fields to identify these records.

I have an ID in HomeOwners (which is unique)
I have a blank ID field in table X (the Imported table).

I am trying to use this SQL statement in a query
UPDATE x SET x.id = HomeOwners.ID WHERE HomeOwners.Phone = X.phone

When I run this in access it prompts me for HomeOwners.Phone and
HomeOwners.ID.
 
You have to join them by the phone.

Try this SQL:

UPDATE X INNER JOIN HomeOwners ON X.PHONE = HomeOwners.PHONE SET X.ID =
[HomeOwners].[ID];
 
Back
Top