Re: FTP script from AS400 to excel

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

Hello Ganesh,

> I need an FTP script to send a file from AS400 to excel sheet in my PC.
[SNIP]
> I need to transfer a formatted file from AS400 and after the transfer
> those fields should be aligned in the subsequent excel sheet columns.

Just to make it absolutely clear:  All FTP does is copy data from one 
place to another.  It does not change the format of that data.

It's like CRTDUPOBJ, except that it copies data over a network.

It does NOT change the format of a file from one thing (a PF) to another 
(an Excel document).  If you want to do that, you need to run a separate 
program first that translates the PF to an Excel document, and then you 
can use FTP to copy the Excel document.