my data is coming from excel sheet and data stored in my table i want to know how to del previous data from table while opening new excel file
my data is coming from excel sheet and data stored in my table i want to know how to del previous data from table while opening new excel file
If your question gets answered, please mark the reply (or replies) containing the answer (by using "Did this answer your question? > Yes" at such replies).
thank u
I think the table is Evs_Excel_Table, if it is correct, you should use x++: delete_from Evs_Excel_Table;
You can use delete_from statement to delete records in bulk.
Just call delete_from myTable to delete all data in it.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156