Automate upload of Excel data

["Burns, Bryan" <Bryan_Burns@xxxxxxxxxxxx>]

I've been asked to automate the manual process of uploading a file and I'd like 
some suggestions.  I've done some searching but can't find the exact process 
I'm looking for.  I've found a lot on loading Excel with iSeries data but we 
want to do the reverse.  We want to upload an Excel spreadsheet to the iseries 
automatically.

The current process is to 

1.  open a Microsoft Outlook email
2. open the Excel CSV spreadsheet attachment that's part of the email
3. alter the spreadsheet by adding a column and filling the column with a 
distributor ID
4. upload the CSV file data to the iSeries using a saved Client Access Transfer 
function 

Is there a third party application that can perform 1, 2 and 3?  Can item 4 be 
performed with a CLP?

Thanks in advance, 

Bryan Burns
IBM Certified Specialist - iSeries System Command Operations V5R2 
M.I.S. Department
ECHO, Incorporated
www.echo-usa.com