Output AS400 spool file to Excel Spreadsheet
Neal Horsley
involved in taking a spooled report from the AS400 over the LAN and finally
viewing that report in an excel spreadsheet on a windows workstation. An
overview of those steps would be a great gift to me. TIA.
Kenneth T. Butterworth
record length of the spool file (132?).
2. Copy the spool file (CPYSPLF) to the physical file.
3. Use Client Access or FTP to download the physical file to a file with
a ".txt" extension on the PC.
4. Inport the file into Excel
I hope that helps.
KB
Neal Horsley <nhor...@worldnet.att.net> wrote in message
news:5zq35.13214$Xx5.6...@bgtnsc06-news.ops.worldnet.att.net...
Richard Schoen
Consider taking a look at our WinSpool/400 and DataImport products.
These products allow you to download and convert reports to spreadsheet and
database formats.
For more information and a software demo CD, contact me directly or take a
look at our web site.
Regards,
Richard Schoen
RJS Software Systems Inc.
"The AS/400 Report Distribution Experts"
Email: ric...@rjssoft.com
Web Site: http://www.rjssoft.com
Neal Horsley wrote in message
<5zq35.13214$Xx5.6...@bgtnsc06-news.ops.worldnet.att.net>...
Lptoro
There website is http://www.paeinc.com
Regards,
Paul
Gilad Gordon
i hope you use client-access to connect to the 400. if so, follow these
steps:
first, you need to create a physical file, with a record length of 198:
CRTPF mylib/myfile RCDLEN(198)
next, you need to copy your spooled file to the physical file:
CPYSPLF FILE(myspool) TOFILE(mylib/myfile) JOB(job_number/*n/job_name)
SPLNBR(spool_number)
next, use CA's "data transfer from AS/400". in the "output device" combo
select "file" and click "details". select "translate EBCDIC to ANSI".
if you use "data transfer from AS/400" to transfer a REAL database file, you
can also specify a file type of BIFF3,4 or 5 which is EXCEL format.
hope this helps,
--
Gilad Gordon
Segment IT (Israel)
gi...@segment.co.il
Neal Horsley <nhor...@worldnet.att.net> wrote in message
news:5zq35.13214$Xx5.6...@bgtnsc06-news.ops.worldnet.att.net...
S-Ence
then use an ODBC data source to link it to the Excel spreadsheet. You
should be able to use the OnOpen properties of the workbook to automatically
create the connection when you open the spreadsheet.
S-Ence
_________________
Gilad Gordon <gi...@segment.co.il> wrote in message
news:8iog1u$9sk$1...@news3.inter.net.il...
Thomas
Probably the easiest way is to use Operations Navigator from Client
Access if you have it. Open the OpsNav view of your AS/400 to <Basic
Operations>/<Printer Output>, drag the spoolfile that you want to your
desktop, then drag/drop the resulting icon onto Excel. Done.
Just like Windows would do it, eh? Hmmm... well, actually I haven't
quite figured out how to get a lot of Windows spoolfiles into something
such as Excel, but I'm sure Windows can do it.
Tom Liotta
In article <5zq35.13214$Xx5.6...@bgtnsc06-news.ops.worldnet.att.net>,
"Neal Horsley" <nhor...@worldnet.att.net> wrote:
> I'm a VB programmer but am new to AS400 and cannot visualize the steps
> involved in taking a spooled report from the AS400 over the LAN and
finally
> viewing that report in an excel spreadsheet on a windows workstation.
An
> overview of those steps would be a great gift to me. TIA.
>
>
--
Tom Liotta
AS/400 systems programmer
Sent via Deja.com http://www.deja.com/
Before you buy.
Bradley V. Stone
http://www.bvstools.com/spltool.html
Won't cost an arm and a leg either. I hear it's great support too! :)
Brad
In article <5zq35.13214$Xx5.6...@bgtnsc06-news.ops.worldnet.att.net>,
"Neal Horsley" <nhor...@worldnet.att.net> wrote:
> I'm a VB programmer but am new to AS400 and cannot visualize the steps
> involved in taking a spooled report from the AS400 over the LAN and
finally
> viewing that report in an excel spreadsheet on a windows
workstation. An
> overview of those steps would be a great gift to me. TIA.
>
>
--
Bradley V. Stone
BVS/Tools - www.bvstools.com
Netshare400.com - www.netshare400.com