M
mark grizzle
Make a backup copy of your mdb.
Attach or import the new table.
Add both tables to an update query.
Join the tables in the query with a unique value from
your data, ssn, telephone number, name and address, etc.
Drag the fields being updated from the original table
into the query grid.
Enter newtable.fieldname into the matching column's
UpdateTo field)
Run the update.
Attach or import the new table.
Add both tables to an update query.
Join the tables in the query with a unique value from
your data, ssn, telephone number, name and address, etc.
Drag the fields being updated from the original table
into the query grid.
Enter newtable.fieldname into the matching column's
UpdateTo field)
Run the update.