Hi,
Hopefully Im not confusing my original question.
Im using access to create and run the query but I would like the data to be in SQL.
Currently I have an Excel spreadsheet which is a replica of the table - linked to Access. This spreadsheet has the missing records in Column A.
I have the live SQL data\table linked to Access (which has the missing records) and I have created the following query to update the SQL table with the missing records
UPDATE Data INNER JOIN Table1 ON Data.unique_id = Table1.unique_id SET Table1 = [Data].[Record]
WHERE (((Table1.ST_Period)="07") AND ((Table1.ST_Year)="18"));
If I test this against a local copy of the SQL table it works if I try and run the update query against the SQL table it errors as above operation must use an updatable query.
If I try to run an update query from the working local table to the sql table it errors also with operation must use an updatable query.
Thanks
|