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

 Srilipta Nanda (SriliptaN)
TATA Consultancy Services Ltd

TATA Consultancy Services Ltd
IN
SriliptaN Member since 2017 4 posts
TATA Consultancy Services Ltd
Posted: Oct 4, 2017
Last activity: Oct 4, 2017
Posted: 4 Oct 2017 4:57 EDT
Last activity: 4 Oct 2017 7:30 EDT
Closed

How to insert data into an excel sheet from database

Hi,

I want to know how to insert data into an excel sheet from DB2 database..

Regards

Srilipta Nanda

To see attachments, please log in.
Data Integration

Posted: 7 years ago
Posted: 4 Oct 2017 5:14 EDT
John Pritchard-Williams (JOHNPW_GCS) Client Support Team Lead
Pegasystems Inc.
GB

Probably high-level you might want to do this:

1. Map your DB2 Table into PRPC as an 'External Table'.

2. Create a PRPC 'Report' based on that data.

3. Use the 'Export To Excel' facility (which is built into the Report Viewer) to generate your Excel file.

 

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