Thank you Erez.
I ended up importing the spreadsheets in to Access and did it via SQL update statements.
Margaret