How to access PeopleSoft tables using MS Access
The title above is a link to a PDF that shows how to set up MS Access so that it can access PeopleSoft tables. It requires an Oracle account username and password. I would be very careful with this. The PeopleCode attached to the records (SaveEdit) and fields (FieldEdit) will not be there to protect the data. So if you write an MS Access program that updates the PeopleSoft tables you will need to read the PeopleCode in the SaveEdit’s and FieldEdit’s and incorporate those same edits in your MS Access program to maintain data integrity. I have not tried this but it might also be possible to get PeopleSoft data directly into MS Excel using the same approach. As always be careful when pulling data down to your local PC. Don’t save sensitive data on your local PC. Windows security seems to be easy to hack.
