Need help dumping Excel info into PeopleSoft. Anyone?
I want to program macros in Excel so when I run the macro, excel will open my PeopleSoft program and automatically type in the fields based on cell entries in Excel. Is this even possible? If so, how is it done?
- LEARN SAPLv 41 decade agoFavorite Answer
Well, if you are looking to import data into PeopleSoft from Excel, you do not need to write macros to do that. if you are having PT 8.44 and above , you get the tool or utility to load the data in PeopleSoft. Also, if you are having Oracle DB, there is another tool called Ora Excel (from www.oraexcel.com)Source(s): http://www.erpfusion.net
- Jeffrey FLv 61 decade ago
I am not familiar with the application, but you can save the excel as a Comma Separated Values (.CSV) and then import the file using the utilities provided with PeopleSoft.
HOW, I don't know, but the CSV file should work.