Question

Date query in excel as database

  • 10 November 2022
  • 1 reply
  • 24 views

Badge +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


1 reply

Userlevel 2
Badge +6

@Abhishek Mishra​ Switch the double quotes for single ones around 'Matched'

 

Failing that - what is the message you are seeing? Will help diagnose.

Reply