Hi there i'd like to ask for some help to update my table something like this:
++++++++++++++++++++++++++++++++++++++++++++++++
OLD.NAME OLD.SIZE NEW.NAME NEW.SIZE
SILK SCREEN 2" STATPACKS SILK SCREEN STATPACKS 2"
SILK SCREEN 4" STATPACKS SILK SCREEN STATPACKS 4"
SILK SCREEN 5.5" STATPACKS SILK SCREEN STATPACKS 5.5"
SNAP RING 14mm SNAP RING 14mm
SNAP RING 2.5mm SNAP RING 2.5mm
SNAP RING 3.5mm SNAP RING 3.5mm
++++++++++++++++++++++++++++++++++++++++++++++++

I have thousands of records like this and kinda hard to edit them one-by-one. Can anyone show me SQL script to update this records?
Your help will appreciated very much.

PS: Im using MS ACCESS