Compare two tables and update on table

[Matze0710]

Hello guys,



I have two tables in access. One normal table and one linked list in SharePoint. the changes in the normal should be compared to the other list and then update the linked list in sharepoint.

Which query can I use to fulfill this? How can I compare values in access?

Best regards

Matthias

[June7]

There is a unique identifier common to these two datasets that can be used to link the records? You want to update every field? Maybe like:

UPDATE SharePointTable SET SharePointTable.Field1=AccessTable.Field1 WHERE SharePointTable.ID=AccessTable.ID

Then if you want to add new records, build a Find Unmatched query and use it as source for an INSERT sql.

But I have never used SharePoint. No idea if linked lists can be edited with an UPDATE or INSERT action.

Bing: Access update SharePoint list
https://social.msdn.microsoft.com/Fo...orum=accessdev