Updating a table using update query from linked csv (1 Viewer)

Hi. I have a db of monthly costs and forecasts. As each month closes, I want to update the actual costs table from a download (csv) from our financial system which includes any prior months that were amended. Due to output format, I have to run a query to parse out the specific fields I need. I have an append query set to add new actuals, and primary keys set so there are no duplicate entries, but when I try to run an update query, it doesn't work. I've tried linking the desired table to the query and it'll display the correct data but it gives me an error. :banghead: Can anyone please help?

I've attached the query for reference.

Hi. If it's not supported, you may have to create a temporary table based on your linked data and then use it to update your regular table.