Hi to all
I am manipulating data in an excel file with SQL connection and "select" or "Update" Statements.
If the excel file is opened, the update statement is working, values are changed.
When the excel file is closed, flow runs through, no error messages, but when the excel is opened nothing has changed.
To test how it works I made a 'select' Step before updating the excel and one 'select' step after updating the excel. The result of the 2nd select statement shows the manipulated data, but when I am opening the excel everything is unchanged...
Data Before Update
The Excel Values remain the same !!! How can this be? I don't understand it as the 2nd select statement gets the correct results...Why is this change not remaining in the excel?
Can anyone help?
Thank you
SwiPowE
