Using Excel as Database - Update command sometimes doesnt work correctly. Why could it be?

  • 18 October 2022
  • 2 replies

Userlevel 3
Badge +10

It doesnt give an error, but it someimes updates the related field in the excel, but sometimes doesnt update, without giving an error

2 replies

Userlevel 4
Badge +7

Hi @Semih Öztürk​ ,


It could be because of extra spaces that make the column values fail whatever filter you are using.

Could you try trimming the column value and try update it (TRIM([ColumnName]))?


Kind Regards,

Ashwin A.K

Badge +6

You say doesn't give any error, does this mean you are wrapping in a Try/Catch block? What is the syntax of the call you're making that only sometimes works?