Hello,
I am trying to update the excel sheet with SQL query but I observe this error for alphanumeric value
“update [”+sheetname+“$] set [StartTime]='”+In_StaartTime+“‘, [EndTime]=’”+In_endTime+“‘,[Status]=’”+Status+“’ Where InvoiceNumber ='”+in_invoiceNumber.ToString+"’ "
variable invoiceNumber in patter ’ " " ’
This query works if InvoiceNumber is Int (123)
The error is observed if the InvoiceNumber is (123A- alphanumeric)
Your guidance is appreciated
Thanks
Greeshma