How to insert data to database from an excel sheet( having multiple rows of data).the data also needs to be shown in an window before inserting it to database.The excel sheet format is predefined which also contain date type value.User will only fiil up the required data set in excel sheet.click on attach and browse button to browse to the path where excel sheet is kept and then to show whole excel data in an window and then click on submit button to insert data into database.and while doing so it will check whether same data exist in the data base or not.suppose the excel contain 7 rows of data.while inserting it shows Duplicate=1,data Inserted=6.can anyone pls illustrate the whole process step by step with screen shot.
Share this page
Related content has not currently been identified for this post.
We'd prefer it if you saw us at our best.
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.