Re: Download to EXCEL from Relational DB

Select <New Data Source>, iSeries Access ODBC Driver, Server, Connect,
Server, Library List.

On 11/27/06, Don Cavaiani <dcavaiani@xxxxxxxxxxxxx> wrote:

Scott - this looks simple and may be something we will use. I see that
it brings up the files in QGPL.  Is there a way to look at other
libraries as well?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Wednesday, November 22, 2006 1:51 PM
To: Midrange Systems Technical Discussion
Subject: Re: Download to EXCEL from Relational DB

> I have a client that would like to be able to download data from their

> iSeries to an EXCEL file. The problem is that the data files are setup

> in a "relational" manner, not a flat file. Is there any PC product
> that will allow me to define the relationship between the files but
> have that complexity hidden from the end user?

Hmmm... in my copy of Excel, I can click Data / Import External Data /
New Database Query.  It bring up a list of files (or "tables" in
SQL-speak) and a list of the fields (or "columns") that those files
contain.  I can choose the fields I want, from more than one field (if I
need to) and it'll bring them all into my spreadsheet.

Once I have the stuff I want, I can even save the query in a file so I
don't have to go through the whole process again next time.

As far as I know, the only thing you need to do this (besides Excel, of
course) is an ODBC driver.  There's one included with i5/OS (OS/400), as
a free component of iSeries Access.

It surprises me that so many people are referring you to commercial
packages, when this is something I take for granted as a feature
built-in to office. I suppose the commercial methods are more powerful
or simplify part of the process?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.