× 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.



And what if your company (us) quit using MS Office years ago, opting for
Google Drive instead? I'm sure there's no option for that. :)

We do use Libre Office a bit. I'll have to try that later.

On Fri, Jun 14, 2019 at 9:46 AM Steinmetz, Paul via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

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>
--
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
--
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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.