Want to delete more than 5000 items in a sharepoint list : a better way is here

Its a very common issue that you face, to delete bulk data from a SharePoint list (above 5000) .

Everyone would run into the error  : Sorry Something went wrong

Tried deleting from SharePoint designer too , it did not help ...

After hours of trial and error found out something cool for this : MICROSOFT ACCESS to the rescue :

Open Access

1. create a blank database.

2. go to External Data and in the Import & Link section Choose SharePoint List

3. Connect to the SharePoint list

4. Click Next, and choose the list you want to work with . Click OK.

 Open the table ,select any items you want to  edit or delete.

Thats it ...