+5
Hi,
I am using excel as database & pass date of birth (picked from excel) in an update query as below :
Update [Sheet1$$] set Status ="Matched" where DOB ='11/10/2022' but I am getting a syntactical error pop up.
Can anyone please help me with conversion or casting or is there anything else that I am missing
+7
@Abhishek Mishra Switch the double quotes for single ones around 'Matched'
Failing that - what is the message you are seeing? Will help diagnose.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.