Excel as database: Query working, but excel not getting updated

I am using excel as database. My update query gives me correct number of rows updated. But when i check in excel, rows are not getting updated.
Can someone please help me ?

My connection string:
“Dsn=Excel Files;dbq=”+excelFileName+";defaultdir=D:;driverid=1046;maxbuffersize=2048;pagetimeout=5;IMEX=-1"

Are you using any excel related activities for this operation to write the values in the excel?

Can i see you workflow seems interesting.


cheers :smiley:

Happy learning :smiley: