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

[Chuck Lewis <CLEWIS@xxxxxxxxxx>]

Rob !

Thanks, that was it ! MAN is that slick (and BOY does THAT open up a hole... 
<BG>...
I've learned a BUNCH in a little information and I SURE appreciate your help !

Chuck

Rob Berendt wrote:

> CD \workdir
> is ran before you start TCP/IP to change into whatever your working directory 
>is on your PC.  I use lower case to signify put your own values here.
>
> So you can ping your 400 and you are connecting with TCP/IP via NT - this is 
>a good start.  Let's check and see if you've started the FTP server.  Do a 
>NETSTAT and take option 3 or do NETSTAT OPTION(*CNN).  Do you see:
> Local
> Port
> ftp-con >
> If not then do STRTCPSVR SERVER(*FTP)
> Again do the NETSTAT and check.
> If this is now going try the following on your NT client:
> Start
> Programs
> MS Dos command prompt
> ping         use either your AS/400 name as defined by your Domain Name 
>Server (DNS) or use the ip address with the format xxx.xxx.xxx.xxx.  One of 
>our 400's is named GDISYS.
> If the ping still works then try
> ftp             use either your AS/400 name as defined by your Domain Name 
>Server (DNS) or use the ip address with the format xxx.xxx.xxx.xxx
> In our case we use:   ftp gdisys
> We get:
> Connected to gdisys.sna.ibm.com
> 220-QTCP at GDISYS
> 220 Connection will close if idle for more than 5 minutes
> User (gdisys.sna.ibm.com:(none)):
> I then enter my AS/400 user id.  Then I get:
> 331 Enter password.
> Password:
>
> Try this.
>
> CLEWIS@IQUEST.NET on 06/30/98 10:44:49 AM
> Please respond to MIDRANGE-L@midrange.com@Internet
> To:     MIDRANGE-L@midrange.com@Internet
> cc:
> 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
+---