Hi can anyone help me with this?..
I’m Using excel as DB and Performing some select,update queries.
Select statement is working fine everywhere.
Execute non Query: SQL update query is updating with an empty value if we perform it after performing some excel activities like read or write on the same excel. But if i update the table before reading/Writing the excel, the update query is updating well… What is the cause of this issuePlease??? Why the table is not updating after perming excel activities???