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

Question

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.

is the double quote at the end where line part of the original query? — Luis LL
– Luis LL, Commented Aug 12, 2013 at 8:20

Adi Inbar · Accepted Answer · 2014-04-10 05:07:56Z

4

An UPDATE query using FROM is possible in SQL Server, but not in MS Access. Use this instead:

UPDATE Tabela1 INNER JOIN Tabela2 ON Tabela1.ID = Tabela2.ID 
SET Tabela1.Sales = [Tabela2].[Sales2];

edited Apr 10, 2014 at 5:07

Adi Inbar

12.4k13 gold badges60 silver badges71 bronze badges

answered Aug 12, 2013 at 8:36

Poonam

6794 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

hakubaa Over a year ago

Thanks, It's working fine:) but mayby you know also way the query with FROM is not? Is it sth with Access ?

Poonam Over a year ago

Query using "from" is not possible in access.But it's possible in sql.

Adi Inbar Over a year ago

@user2674174 If your question has been answered, please mark the answer that you feel best addressed your question as accepted. You can also upvote the accepted answer and any other answers you found useful.

user1957877 · Accepted Answer · 2013-08-12 08:22:49Z

0

UPDATE Tabela1 SET Tabela1.SALES = Tabela2.SALES2 FROM Tabela1,Tabela2 WHERE Tabela1.ID = Tabela2.ID

answered Aug 12, 2013 at 8:22

user1957877

1 Comment

hakubaa Over a year ago

Thanks, but it dosen't help.

Luis LL · Accepted Answer · 2013-08-12 08:27:23Z

0

try this

UPDATE Tabela1 
SET Tabela1.SALES = Tabela2.SALES2 
FROM Tabela1 
INNER JOIN Tabela2 
WHERE Tabela1.ID = Tabela2.ID

answered Aug 12, 2013 at 8:27

Luis LL

2,9932 gold badges21 silver badges22 bronze badges

Comments

Rupam · Accepted Answer · 2016-06-07 11:41:03Z

-1

Update TABLE2, TABLE1
SET TABLE2.SALES2 = TABLE1.SALES
WHERE TABLE2.ID=TABLE1.ID

hey friends try this 100% working. As per poonam FROM statement is not possible and its true but no need to inner join and make your query slow down.
This SQL Query will run on MS Access only.

edited Jun 7, 2016 at 11:41

Rupam

12 bronze badges

answered Jun 6, 2016 at 4:51

Rupam

1

Collectives™ on Stack Overflow

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

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related