several excel files (which contains data downloaded from AS400 database, and is updated everyday) are linked tables in Access, tables with exact identical data from the linked tables were created (so that primary keys can be created), relationships were created between these tables, how can Access automatically update the data in these tables without losing the relationship?, or how can access prevent Appending the new data to the existing tables
