Update Data

  • Thread starter Thread starter DenaK
  • Start date Start date
D

DenaK

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
 
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.
Click to expand...

If you just *empty* the table and run an append query to refill it, it
shouldn't remove any relationships, unless you're assigning your own
autonumber primary keys and linking them to foreign keys in other (local)
tables. Surely the Oracle/PeopleSoft tables have PKs?

John W. Vinson [MVP]
 
Back
Top