Re: getting excell files into Iseries

Steve

<blatant vendor response>
We (RJS Software) have a product called RPG2SQL Integrator that is not limited 
to just SQL processes - it also includes ways to work with Excel spreadsheets 
directly, from your ILE RPG programs. Along with that, it has the ability to 
run VB scripts on the PC from your RPG program. I can see the possibility of 
using such a script to do your login and retrieval - if that can be done 
programmatically - and then RPG2SQL would read the spreadsheets directly.

If you cannot retrieve the docs programmatically, you could do as you describe 
- get the files - but leave them on the PC and let your iSeries get the data 
through RPG2SQL Integrator.

RPG2SQL Integrator has a library on the iSeries and an app on the PC.

If interested in this kind of thing, give me a call or email or check our 
website.
1.888.RJS.SOFT (toll-free)
www.rjssoftware.com
</blatant vendor response>

Regards
Vern

-------------- Original message -------------- 
From: steema@xxxxxxxxxxxxx 

> HI We have Walmart 816 files (name + Address, etc.) that currently we 
> login to Retaillink, copy and paste the DC's onto the main one, then a PC 
> command copies to our folders. I would rather login, and on the PC side, 
> copy all 4 files ( USA + Canada), to my Iseries, and then let the Iseries 
> combine the 2, rather than my manual way of doing it. 
> 
> Seeking ideas for implementing this. 
> Thanks, 
> Steve 
> -- 
> 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. 
>