SQL/Exel/VBA - UPDATE query: 'Syntax Error (missing operator) in query
expression'
I have very simple query that is not working and I get error:
'Syntax Error (missing operator) in query expression Tabela2.SALES2 FROM
Tabela2'
Here is the code:
UPDATE Tabela1
SET Tabela1.SALES = Tabela2.SALES2
FROM Tabela2
WHERE Tabela1.ID = Tabela2.ID"
I want to run this query from VBA/Excel on Acces database (2007). Others
queries with e.g. SELECT are working fine, so the problem is only with the
query. And I really don't know why it is not working.
No comments:
Post a Comment