Updating tables with data from other tables

[cedar]

Hi-
I have several tables created in a database that act as a type of inventory for similar datasets throughout the organization. These tables contain basic data from other datasets (that are not connected to this database).

I would like to set up some type of system where a person could import their unique tables to my database, and be able to copy the data into my tables. Most of the folks here are not very Access savvy, so I need to create an extremely user friendly system for updating the records (almost automatically).

I was wondering if I could set up a form or a query that would do this, or something similar? Any ideas or suggestions are appreciated!

 

[JerryDennison]

Why not just link the tables? When linked you could control whether or not you want the to be able to change any of the data in these tables and at the same time you have up to the minute info available without the need to re-import.