I am using execute non query (Excel as db) to update excel. It is updating the excel file when file is open, But if the excel file is closed its not getting updated.
Connection string -“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”""+in_FileName+"""; Extended Properties=‘Excel 8.0;HDR=YES;IMEX=0’;"
If excel is closed, I am not getting any error as well, its not updating the file.
Any suggestion on this,
Thanks in advance.