update data between tables with VBA in ACCESS 2010
Posted on 2015-01-12
I have two tables that hold almost the same data, but each has over 200 columns. the key between them is the DealID. The columns that match have the same name, but the destination tables does not have all the columns that are in the source table. So, I need to update the destination table field with the corresponding data from the source table but if there is no matching column, ignore it. I have a query in the database with returns the all the rows since there are matching DealID, but now I need to loop through and put the source data n the destination and not sure how to approach. should I create two recordset queries in the VBA procedure and match on the field names?