	AllExperts > Experts
	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.8), Oracle RDBMS (7.3 - 10g) 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.

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

Topic: Peoplesoft

Expert: Peter Choi
Date: 1/31/2007
Subject: how to upload excel file to peoplesoft database

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

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.