Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Durgesh P (DurgeshP0263)
General Electric Company
Sr Enterprise Application Engineer
General Electric Company
IN
DurgeshP0263 Member since 2017 2 posts
General Electric Company
Posted: Jun 26, 2019
Last activity: Jun 26, 2019
Posted: 26 Jun 2019 1:21 EDT
Last activity: 26 Jun 2019 5:34 EDT
Closed

How to read data from excel and insert into DB table.

Hi,

I have an excel with more than 0.5 million records, i need to insert these records into multiple DB table using a back end activity. how can i read records from an excel and insert in to DB.

***Edited by Moderator: Lochan to update platform capability tags***

To see attachments, please log in.
Dev/Designer Studio
Reporting

Posted: 5 years ago
Posted: 26 Jun 2019 1:35 EDT
Vivek Bommayappan (VIVEKATCTS)
Cognizant

Cognizant
CA

Hi,

  You can use MSOParseExcelFile activity to read the data from excel file. As you want to store it into multiple tables, you can segregate the data to different pages and you can store it to the DB by writing an activity.

Regards,

Vivek

To see attachments, please log in.

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.

Close Deprecation Notice