	AllExperts > Peoplesoft
	Search

About Peter Choi
Expertise
I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with 10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and 8.x, 9.0), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10g). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x and 9.0.

You are here: Experts > Industry > IT Consulting > Peoplesoft > how to upload excel file to peoplesoft database

Peoplesoft - how to upload excel file to peoplesoft database

Expert: Peter Choi - 1/31/2007

Question
How can i upload data in excel sheet to multiple tables in peoplesoft database like the data in excel is splitted into header and detail peoplesoft tables.

Thanks in Advance.

Answer
Hi Iavanya,

The tool to use is PeopleSoft's Application Engine. Essentially you will need to convert each tab in your Excel file to a .CSV format.

Then using Application Engine, you map the PeopleSoft Table fields to the CSV file. Once that is confirmed, you can run the program to load the data in.

Reference:
http://download-east.oracle.com/docs/cd/B31274_01/psft/html/docset.html
and select " PeopleSoft Application Engine ".

Alternatively, you can use write SQR programs to perform your data load

http://download-east.oracle.com/docs/cd/B31274_01/psft/html/docset.html
and select " SQR for PeopleSoft Developers ".

Hope this helps!

Peter

Add to this Answer Ask a Question