RE: DB2 files to excel files (and vice-versa)

Here is an article on SQL2XLS. It does the DB2 to XLS that you're interested in. We've modified it quite a bit for our own uses, and to generate newer .xlsx format.

https://www.mcpressonline.com/programming/sql/techtip-sql2xlsx-the-starter-kit

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Chris Chambers
Sent: Friday, June 14, 2019 9:30 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: DB2 files to excel files (and vice-versa)

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.


Hi Guys,

Can anyone recommend a tool that outputs direct to excel. I'm thinking of an equivalent of CPYTOIMPF but direct as .xls / .xlsx rather than .csv

I am also interested in the converse operation - think CPYFRMIMPF but from .xls / .xlsx rather than .csv

I know there are many tools out there but I'm not aware of all of them and some are astonishingly expensive

NB - This is not about converting spool files to excel - we are talking physical files

Many Thanks

Chris Chambers

www.backbeatsolutions.co.uk

<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com