May
7
2009
MS Access: Update rows using another table
My problem was I wanted to update data in one table based on the data in another table. In this senario I had two identical tables in my MS Access database. Table1 is the original and Table2 has been imported from Excel. This MS Excel spread is an exported version of Table1 which was updated off network. Changes made to the Cash column now need to be reflected in the original Table1 .
I’m by no means an MS Access expert but know this is easily achievable through normal programming languages including directly through SQL. But my goal was to simply achieve this using the MS Access interface. A quick trawl of the internet didn’t turn up any results so I quickly worked it out for myself and am sharing for future googlers!
