There's a couple of pretty straightforward ways of doing this.
1) The quick and dirty way: Use an Excel formula (in the last cell in each row) to concatenate together the values into a SQL statement (1 for each row). You can then run them in the SQL tool of your choice.
2) The 'proper' method: Use ExcelToCI. This is an Excel upload tool which will run all the page validation etc. There's more to it than I can write here, but this is the link to the section on it in PeopleBooks: http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tcpi/book...
Peoplesoft ISIS
104 members
Description
PeopleSoft ISIS group aims at student and campus management issues and solutions for consultants to give complete configured solutions and tips
How to automate PeopleSoft using Excel VBA.
by Edna Whelan
Aug 29, 2013
There's a couple of pretty straightforward ways of doing this.
1) The quick and dirty way: Use an Excel formula (in the last cell in each row) to concatenate together the values into a SQL statement (1 for each row). You can then run them in the SQL tool of your choice.
2) The 'proper' method: Use ExcelToCI. This is an Excel upload tool which will run all the page validation etc. There's more to it than I can write here, but this is the link to the section on it in PeopleBooks: http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tcpi/book...