View Single Post
 
Old 10-31-2018, 06:31 AM
shabbaranks shabbaranks is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default

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
Reply With Quote