I need to upload data from PeopleSoft 8.9 on a regular basis to an Access
Database.  As this is employee data and changes regularly I need to be able
to update the records with new information for employees already in the
system.  I would like to link the two databases directly but our ISD will not
allow me to do so, which means I am stuck running a query every week and then
uploading the data.  

Is there anything I can do that will allow me to update the old info with
the new?  I don't want to simply write over the table every week because I
would lose my relationships in numerous queries.

I appreciate any help.

Dena