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

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

>To avoid writing any CGI or RPG at all, you might as well use a Java
Servlet
>program (to write the web page's HTML table  directly) with JDBC access to
>DB2/400. JDBC would also give you access to the 'Meta Data' or field
>definitions which would let you build an HTML table for any file. This
could
>all run natively on the AS/400 at V4R3 with the HTTP server running. A very
>nice project for someone!


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