Question

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

  • 18 October 2022
  • 2 replies
  • 15 views

Userlevel 3
Badge +9

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 3
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

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?

Reply