I posted this to the PeopleSoft forum but there doesn't appear to be much activity in that forum - and the topic applies equally here. I want to export about 6 Employee fields (Emp#, LastName, FirstName, Dept, etc.) from a PeopleSoft HR package to an Access database. Does PeopleSoft have an export function? If so, can it be saved as a template so that it can be run whenever needed? And third, what export formats are available (textfile, dbf, Access, etc.)? Thanks. Note - I don't have PeopleSoft installed - I am trying to help an Access user at another location.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
PeopleSoft export to Access
- Thread starter evalesthy
- Start date
bjbrummett
Technical User
I have used PeopleSoft a couple of times and created a query which can be exported to an EXCEL spreadsheet. From there I import the EXCEL spreadsheet into ACCESS. There may be another way, but that was quick and easy.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question