RE: iSeries Acces File Transfer

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 
______________________________________________________________________