Skip to main content
Question

Mass deleting records using info from a spreadsheet

  • February 12, 2020
  • 0 replies
  • 36 views
I have a spreadsheet with 2400 or so Workstation names that represent records in the Workstation table that need to be deleted. Is there a better way to go about deleting these records than finding them one by one in the table? My initial thought was uploading the spreadsheet matching the field and it would potentially just update those fields and I could then search by last modified perhaps. But not sure if that will work like I am thinking, specifically because the upload won't actually change any info.

------------------------------
Chris Swirtz
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • February 12, 2020
Chris,

Yes you want to upload the spreadsheet matching the current Record ID#.   The trick here is to add a column of data with the value of "1".   When you import create a new field as a Check Box.   Call it Temp Delete or some other variant on that.

After the import you can run a custom report where you set the filter:

[Temp Delete]=True

Then delete all the records in the report.

Poof.  They are gone.

I suggest going back into the table and getting rid of the new field so that it will not cause confusion in the future.


 


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement