Hi Guys.
I have a problem.
i am using VBA of Excell 2003 and ADO to access rows in a worksheet.
When i execute this SQL statement: "UPDATE [Dados Gerais$] SET [Planejamento JUL/06 (P)]=30 WHERE [Grupo do Servico]='ALVENARIA' AND [UnidadedeMedicao]='PISO 11o PAVIMENTO'"
, excel return this error:
"cannot update '(expression)'; field not updateable"
anyone can help me
Error when update a row using ADO
Chris Kinsey
Per our support engineer:
Thanks for using Microsoft ISV Community Forum, according to your problem, I’m wondering what’s meaning of “Planejamento JUL/06 (P)”, it is a column name If so, I believe it is the root cause of your problem because there are some characters like “/”, “(“ , “)” may be recognized as mathematics operators. And thus ADO will recognize the whole string as an expression rather than a field name that finally lead to the error.
As a resolution, please remove the symbols from the field name (for ex, Planejamento200607 or something) and test again whether your code works.
-brenda (ISV Buddy Team)