Using and Append (or update) Query to update a table from a linked table.

  • Thread starter Thread starter Plim
  • Start date Start date
P

Plim

Guest
Each day I receive a "daily" file in Excel that contains data I must upload to the "master" table. The primary key in both of these would be the telephone number. I can link and Import this daily file each day but I seem to be having trouble constructing an append query. This query should look at the key, or the telephone number, and for each match move the customer’s new data into the master table. I have both tables constructed, dataset are the same (date/time, text and so on) yet when I try to append, I receive an error. Could my query be constructed incorrectly or the data types are not matching. I checked the datatypes and they do look like they match!
Any ideas would be greatly welcomed.
 
Append queries are used to ADD NEW ROWS to a table. Update queries are used to UPDATE EXISTING ROWS. The following is an article that will describe how you can create an update query that will append new rows for unmatched entries.

Q127977 - ACC Updating and Appending Records in One Update Query

BTW - telephone number is a poor choice for a primary key. What happens if someone's phone number changes? How would you ever match the linked table to the Access table? Primary keys should always be unchangeable.
 
You referenced this article:

Q127977 - ACC Updating and Appending Records in One Update Query

But it is not showing as link. How do I find this article. This is something I need to do.

Thanks
 

Users who are viewing this thread

Back
Top Bottom