web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

delete record from table after open new excel file

(0) ShareShare
ReportReport
Posted on by

pastedimage1578491411333v1.png pastedimage1578491450352v2.png

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 

I have the same question (0)
  • Verified answer
    nmaenpaa Profile Picture
    101,160 Moderator on at

    Just call delete_from myTable to delete all data in it.

  • Verified answer
    Martin Dráb Profile Picture
    237,961 Most Valuable Professional on at

    You can use delete_from statement to delete records in bulk.

  • Verified answer
    Michel Chacaliaza Profile Picture
    104 on at

    I think the table is Evs_Excel_Table, if it is correct, you should use x++: delete_from Evs_Excel_Table;

  • Community Member Profile Picture
    on at

    thank u

  • Martin Dráb Profile Picture
    237,961 Most Valuable Professional on at

    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).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans