Monday, 12 August 2013

SQL/Exel/VBA - UPDATE query: 'Syntax Error (missing operator) in query expression'

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