RE: Automating data from AS/400 to Microsoft Access.

["Christopher J. Jewell (Jewell Consulting)" <jewellcj@xxxxxxxxxxxxxxxxx>]

Roger:

Servlets are an excellent way of replacing your CGI programs which are quite
cumbersome to program. Servlets also produce a stream file of HTML directly
to the client, so I see no reason why this wouldn't work either. I have used
VisualAge's Servlet Builder to produce web pages with Java Servlets: it's a
great technique, and reasonably easy to learn: also you don't have to learn
HTML or CGI! For more information, there's an excellent book published by
O'Reilly called 'Java Servlet Programming': search Amazon.com with
'Servlet'.

Chris Jewell

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Roger Pence
> Sent: Friday, December 04, 1998 10:36 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Automating data from AS/400 to Microsoft Access.
>
>
> Chris---
>
> The Excel Web query technique, when used with an RPG CGI program, doesn't
> actually read an HTML table. Rather, the CGI program outputs the HTML to a
> stream file which gets passed directly back into Excel. It is a
> clean, neat
> little solution--that doesn't require V4R2+ or Java.
>
> The solution you propose is indeed interesting, but many steps up the
> complexity ladder if all you want to do is get data directly into Excel.
>
> rp
>
>

+---
| 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
+---