Hi Richard

I am writing to you as I have been looking for an answer for this error for a few months now and unable to find any answers on how to resolve this issue.

The error that I get is - data cannot be inserted because there is no matching record.

What I am trying to do is update an existing record on sharepoint (list in sharepoint) with a most recent data download in excel. This excel file is saved on a local folder which is linked on Access.

So, when I run the update query, I get this error. I really need help.

If you can either reply when you have a moment and/or make a video on your channel, it would be much helpful. There's nothing online that I can find and as a last resort I am emailing you.

Thanks for your help in advance.