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

[Chuck Lewis <CLEWIS@xxxxxxxxxx>]

Thanks Pete !

I'm working on the per Rob's post and per my reply to him, having a problem 
(duh...)

Chuck

Pete Hall wrote:

> At 12:59 PM 6/29/98 -0400, Chuck Lewis wrote:
> >Any one know of a quick and easy way to get an AS/400 printout into an
> >Excel spreadsheet ?
>
> Use CPYSPLF to put the spooled output into a physical file (CTLCHAR(*NONE)), 
>FTP that to an ASCII file with a .TXT extension and just open it with Excel, 
>which will prompt you for import information (column positions, data types, 
>starting column, starting row). Once you've got it into the spreadsheet, sort 
>the data to make the headers all gravitate to one spot in the spreadsheet so 
>that they can be deleted with one swell foop.
>
> hth
> Pete
>
> Pete Hall
> peteh@inwave.com
> http://www.inwave.com/~peteh/
>
> +---
> | 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
+---