×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
The new/latest ACS (Access Client Solutions) has an output option directly to EXCEL.
1) Open a blank EXCEL worksheet.
2) From IBM I
3) File name: type or browse to your file
4) Data option - change only if needed
5) Output device - change to Active Excel Spreadsheet
6) Format option - change only if needed
7) Start transfer
Also has the vica-versa option.
1) Open your EXCEL
2) Input device - change to Active Excel Spreadsheet
3) Library/file member - type or browse to
4) Details - change only if needed
5) Start transfer
Paul
-----Original Message-----
From: MIDRANGE-L [mailto: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)
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>
midrange.com
