RE: FTP script from AS400 to excel

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Ganesh

Your PC can see anything on the iSeries through Windows networking shares 
(NetServer is how the iSeries implements this). So using to put something 
in the non-library part of the IFS is the same functionally as sending it 
to a PC. Just don't put anything under QDLS, for many reasons. Do a google 
on QDLS or use the iSeries Support site search for more info there.

Also, I recommend a tab-delimited layout - Excel knows how to handle it. I 
forget whether leading zeroes are preserved - probably not.

OTOH, we have a product with functions for working directly with Excel 
workbooks - cell formatting, even. calling VBScript to do almost anything 
you can do with OLE automation. RPG2SQL is not just about SQL - it also 
does XLS.   www.rjssoftware.com to get more info

HTH
Vern

At 11:09 AM 6/16/2005, you wrote:


> But CPYTOIMPF converts DB400 file to stream file which is placed under
> some specific directory/folder. But I need to send it to an excel sheet
> in my PC.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of phil Kestenbaum
> Sent: Thursday, June 16, 2005 9:12 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: FTP script from AS400 to excel
>
> Ganesh, have you looked at: CPYTOIMPF it also does this and allows field
> separators and delimiters.
>
> -----Original Message-----
> From: ganeshkumar.murugesan@xxxxxxxxx
> [mailto:ganeshkumar.murugesan@xxxxxxxxx]
> Sent: Thursday, June 16, 2005 11:23 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: FTP script from AS400 to excel
>
>
>
> I need an FTP script to send a file from AS400 to excel sheet in my PC.
>
> I know I need to call that script from my windows, using the command FTP
> -S: SCRIPT1.
>
>
> I was able to write a script to FTP my AS400 file to a .TXT file without
> any difficulty. When I use .XLS instead of .TXT, I'm not getting the
> required output.
>
>
> I need to transfer a formatted file from AS400 and after the transfer
> those fields should be aligned in the subsequent excel sheet columns.
>
>
> So if anyone knows anything about this, please let me know.
>
>
>
> Thanks,
> Ganesh
>
>
>
>
>
>
> Confidentiality Notice
>
>
> The information contained in this electronic message and any attachments
> to this message are intended
> for the exclusive use of the addressee(s) and may contain confidential
> or privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or
> Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
> --
> 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 message contains confidential information and is intended intended
> only for the individual named. If you are not the named addressee you
> should not disseminate, distribute or copy this e-mail. Please notify
> the sender immediately if you have received this e-mail by mistake and
> delete this e-mail from your system. Finally, the recipient should check
> this email and any attachments for the presence of viruses. The company
> accepts no liability for any damage caused by any virus transmitted by
> this email.
>
> --
> 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.
>
>
>
> Confidentiality Notice
>
> The information contained in this electronic message and any attachments 
> to this message are intended
> for the exclusive use of the addressee(s) and may contain confidential or 
> privileged information. If
> you are not the intended recipient, please notify the sender at Wipro or 
> Mailadmin@xxxxxxxxx immediately
> and destroy all copies of this message and any attachments.
>
> --
> 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.