Execute non query not working when excel is closed - excel as database

Help Activities
, , , ,
1

Hi,

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’;”

Provider: “System.Data.OleDb”

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?

2

Hi @vigneshnkv ,

Is this issue resolved for you, I am also facing same issue. When excel is open its updating the value.

Let me know your comment on this.

Thank you,

3

I do not have any solution. But do you have any issue in opening excel and updating?