I am using excel a database.
Connection string in connect activity:
“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Input\InputFile.xlsx; Extended Properties=‘Excel 8.0;HDR=YES;IMEX=0’;”
I am trying to update column values based on some conditions using execute no query activity.
This is working fine when the excel is opened. But the update is not happening when excel is closed. There is no error message also. It returns correct affected records count, but no update really.
Any suggestions please?