RE: iSeries Acces File Transfer

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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
>
> ebm-papst UK Ltd
>
> Tel: 01245468555
>
> www.ebmpapst.co.uk
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Guy Terry
> Sent: 22 March 2007 08:49
> To: midrange-l@xxxxxxxxxxxx
> Subject: iSeries Acces File Transfer
>
>
> I'm using iSeries Access Data Transfer to download a file from our i5.
> The first thing I do with this file is open it in Excel and remove all
> rows where the first field has a value of A99.
>
> It seems to me that I must be able to get Data Transfer to not download
> anything where the first field = A99, probably by using the 'Select' or
> 'Where' options under 'Data Options'. Only I can't figure out how to do
> it. Can anyone help?
>
>
>
>
> --
> 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 email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
>
> --
> 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.