Skip to main content
Question

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

  • Oct 18, 2022 8:47 AM UTC
  • 2 replies
  • 153 views
Forum|alt.badge.img+1

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
    • Ashwin A.K
    • Navigator | Tier 3
    • Oct 18, 2022 11:27 AM UTC

    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

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Most Valuable Pathfinder
    Forum|alt.badge.img+7
    • JLogan3o13Most Valuable Pathfinder
    • Most Valuable Pathfinder
    • Oct 19, 2022 4:05 PM UTC

    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?

    Terms & ConditionsAccessibility statement