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


  1.  Home
  2. MIDRANGE-L
  3. June 2019

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

I second the recommendation to use CoolSpools. It is an awesome product for any type of database/spooled file conversion. It also has a better SMTP server than IBM's MSF. We use it in a ton of programs to email or ftp files in different formats and have never found that it couldn't do whatever we needed it to. It's reasonably priced and their support is great.

Linda Wagner
Software Engineer II, Finance & Revenue Solutions
Avenu Insights & Analytics
----------------------
message: 4
date: Fri, 14 Jun 2019 09:49:34 -0400
from: dlclark@xxxxxxxxxxxxxxxx
subject: Re: DB2 files to excel files (and vice-versa)

We use CoolSpool for this, which (among other things) includes a command to convert database files directly to XLS or XLSX. For the reverse, we just use Excel to Save As a CSV and then CPYFRMIMPF.

Sincerely,

Dave Clark



As an Amazon Associate we earn from qualifying purchases.

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

This mailing list archive is Copyright 1997-2025 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.