• Subject: Re: Uploading Excel to AS/400
  • From: Don <dr2@xxxxxxxxxxxxxxxx>
  • Date: Fri, 1 May 1998 09:40:06 -0400 (EDT)
  • cc: MIDRANGE-L <MIDRANGE-L@xxxxxxxxxxxx>
  • In-Reply-To: <5022400801051998/A86028/TIMONE/11C50A281500*@MHS>


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
+---


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].