Append or Update - Access 2010
Posted on 2013-11-14
I have a database that has 50,000 records. There are 82 columns in the db, one of which is a Lot #, that can't be duplicated and one that displays the path to a scanned document. Of those 50k records only a hundred of them have a path. I had an excel file that has 4k lots that I have the path info. So I imported that Excel file and created a new table. What's the easiest way to get all the paths from the new table into the original table? Would that be an append query? Remember, I have about 100 records that already have the path info. Or is this an update query? I've never done either so don't know where to start.