RE: Generating an excel file from a DB2/400 database -- MIDRANGE-L

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

If you go down the client access road why not use the option to create a
native excel file ?

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Saturday, 31 October 2009 11:27 a.m.
To: Midrange Systems Technical Discussion
Subject: Re: Generating an excel file from a DB2/400 database

Just generate a CVS using Client Access Transfer and open in Excel. With
Client Access you can click on Data Options and select fields or records.

On Fri, Oct 30, 2009 at 4:03 PM, James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

I just got this question from a customer, and it's not something can
recall ever dealing with myself, other than maybe cutting and pasting
from QuestView running in an emulation session:

It seems they need to get an Excel file from a database file, apparently
being filtered through a query of some sort (whether it's SQL, OPNQYRF,
Query/400, or whatever, they didn't say).

What can they use for this purpose?

--
JHHL

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.