I have exported files to access before, removed the record, and then imported them back but this was at another company. I have not attempted it here.
I changed the field not to allow dates from another year.
Can you tell me how to extract the table into access, clean it up, and teh upload it...