Re: Getting an AS/400 Printout into Excel...

[Chuck Lewis <CLEWIS@xxxxxxxxxx>]

Hi Eric !

Actually they way we have it set up, all I have to do is enter the system name 
and
not worry about the "other stuff".

What I was missing was starting FTP up (we had that turned off for obvious 
reason...
:-))

Thanks anway !

Chuck

Eric wrote:

> Are you using the correct syntax?
> Syntax should be FTP 'xxx.xxx.xxx.xxx'   Include the ticks!
>
> Eric Kempter
> Director of MIS
> Commair Mechanical Services
>
> -----Original Message-----
> From:   Chuck Lewis [SMTP:CLEWIS@IQUEST.NET]
> Sent:   Tuesday, June 30, 1998 6:48 AM
> To:     MIDRANGE-L@midrange.com
> Subject:        Re: Getting an AS/400 Printout into Excel...
>
> Thanks Rob,
>
> Now I become a pest...
>
> What do you mean by the CD /workdir ?
>
> I assume this means any subdirectory on the PC or is it something specific the
> the AS/400's file system ?
>
> I tried starting FTP (and I am a real NOVICE when it comes to stuff like this 
>on
> the AS/400) and I get "cannot connect to host xxxxxx.xxx.xxx.COM (where all 
>the
> x's are valid names) at address xxx.xx.xx.x. (where all the x's are valid
> numbers) try again.
>
> I can ping the AS/400 and I am connecting to the AS/400 via TCP/IP at my NT
> Workstation. Host Servers is started (has to be started for me to connect via 
>CA
> or I get an error), etc.
>
> What am I missing  ?
>
> Thanks !!
>
> Chuck
>
> Rob Berendt wrote:
>
> > CRTPF lib/file RCDLEN(150)
> > CPYSPLF FILE(spoolfile) TOFILE(lib/file) SPLNBR(*LAST)
> > >From PC
> > cd \workdir
> > ftp as400name
> > get lib/file file.txt
> > quit
> > In Excel
> > File Open
> > Follow prompts, suggest fixed width.
> >
> > CLEWIS@IQUEST.NET on 06/29/98 12:39:04 PM
> > Please respond to MIDRANGE-L@midrange.com@Internet
> > To:     MIDRANGE-L@midrange.com@Internet
> > cc:
> > Subject:        Getting an AS/400 Printout into Excel...
> >
> > Hello All,
> >
> > Any one know of a quick and easy way to get an AS/400 printout into an
> > Excel spreadsheet ?
> >
> > Thanks,
> >
> > Chuck
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@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 subscribe to this list send email to MIDRANGE-L-SUB@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 subscribe to this list send email to MIDRANGE-L-SUB@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 subscribe to this list send email to MIDRANGE-L-SUB@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 subscribe to this list send email to MIDRANGE-L-SUB@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
+---