Skip to main content
Question

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

  • October 18, 2022
  • 2 replies
  • 79 views

Forum|alt.badge.img+12

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

Ashwin A.K
Forum|alt.badge.img+10
  • Navigator | Tier 3
  • October 18, 2022

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


Forum|alt.badge.img+17
  • Most Valuable Pathfinder
  • October 19, 2022

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?