Re: iSeries Acces File Transfer -- MIDRANGE-L

Luis

Did you dig all the way down to the details dialog for setting theWhere? It gives you fields lists and operators and all that - verynice - as I recall, MS Query has something like it - you still needsome idea of logical expressions, or am I too long not using MS Query?


Vern

At 09:42 AM 3/24/2007, you wrote:

Vernon,

I think you could be right. If you don't have the CA license thismust be extra cost. In the sites I've worked we have always had CA,so (for me) this is included.

A good point for MS Query is that it could be easier for non-techpersonnel to use (no need to know SQL in order to select somespecific data (e.g. WHERE)).


Regards,

Luis Rodriguez





midrange-l-request@xxxxxxxxxxxx wrote:
------------------------------

message: 2
date: Fri, 23 Mar 2007 22:09:26 -0600
from: Vernon Hamberg
subject: Re: iSeries Acces File Transfer

I think so, Luis. From the Access packaging page, the line about
iSeries Access for Windows:

Must have 5722-XW1 to use PC5250 and Data Transfer

and in the line about 5722-XW1

User Based or Processor Based Purchase

So if you have the emulator you also have Data Transfer.

HTH
Vern

At 07:08 AM 3/22/2007, you wrote:


>Vernon,
>
>Are you sure about this? I have always thought that the ability to
>download files from the iSeries to an EXCEL spreadsheet was free of
>charge. It just came with the Client Access CD, along the ODBC client.
>
>Regards,
>
>Luis Rodriguez
>midrange-l-request@xxxxxxxxxxxx wrote:
>------------------------------
>
>message: 5
>date: Thu, 22 Mar 2007 07:34:52 -0600
>from: Vernon Hamberg
>subject: RE: iSeries Acces File Transfer
>
>He was asking about the iSeries Access download addin for Excel,
>which is an extra cost option - your solution is the Microsoft MS
>Query, which is usually not installed as a part of MS Office but can
>be. Nice thing about MS Query is, it does not cost extra.
>
>Vern
>
>At 02:55 AM 3/22/2007, you wrote:
>
> >In excel click onto Data - Import External Data - New Database Query -
> >Select data source - Select your file - Select fields - Next  at this
> >screen you select what data you need - Next Sort by - Next return data
> >to excel (you can save the query here as well for re use)
> >
> >
> >Regards
> >
> >Steve Dodkins
>
>


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions

---------------------------------
The fish are biting.
 Get more visitors on your site using Yahoo! Search Marketing.
--
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.