Re: iSeries Acces File Transfer

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Luis

Did you dig all the way down to the details dialog for setting the 
Where? It gives you fields lists and operators and all that - very 
nice - as I recall, MS Query has something like it - you still need 
some 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 this 
> must 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-tech 
> personnel to use (no need to know SQL in order to select some 
> specific 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.