Re: Uploading Excel to AS/400

[Don <dr2@xxxxxxxxxxxxxxxx>]

We have a client that needed a excel extract from a daily transactions
file.  What we do is build a comma delimited PF, then CPYTOPCD to a .SDF
on the I drive and he just loads it up in the a.m. when he gets in...it's
part of the the nightly process...it's tons of string work but they're
happy....

Don in DC metro


On Fri, 1 May 1998, Don Schenck wrote:

> ::::I had the same problem. In self defense, I wrote a PC utility that will
> transform a tab delimited file (which excel can produce) to a positional 
>record
> that can be FTP'd to the AS/400. If you'd like a copy, it's free and on my web
> site. The program name is FLATULATE. (Sort of gives you a flavor for how much 
>I
> appreciated this CA functionality.)
> 
> 
> 
> OR ...
> 
> Using VBA within Excel, you could easily produce a file for FTP-ing to the 
>host
> of choice.
> 
> -- Don Schenck, Schenck Technical Consulting
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
> 

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---