It doesnt give an error, but it someimes updates the related field in the excel, but sometimes doesnt update, without giving an error
Using Excel as Database - Update command sometimes doesnt work correctly. Why could it be?
Userlevel 3
+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
+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?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.