Hi,
I have a scenario, where I am trying to update excel using below query -
“UPDATE [“+SheetName+”$] Set [STATUS] =‘“+strStatus+”’, [COMMENT] = ‘“+strComment+”’ Where [LEVEL] LIKE ‘“+row.Item(“Check Level”).Tostring+”’ "
For activity -
Connection string used - “provider=Microsoft.ACE.OLEDB.16.0;Mode=ReadWrite;Data Source='”+strAuditTrailPath+“';Extended Properties=‘Excel 8.0;HDR=YES’;”
For excel version and excel type are as below-
When I execute this activity with above information I have error -“Object reference not set to instance of object” even though I hava values for all variable present in query and connection.
Any suggestion would be helpful