|
Don, Couldn't you use the same program to write to a CSV file on the IFS? Then you could just load the thing directly via the Network Neighborhood function of Windows (Credit to John Carr for this idea). Fritz Hayes -----Original Message----- From: owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com] On Behalf Of Glenn Gundermann Sent: Friday, December 04, 1998 2:17 PM To: MIDRANGE-L@midrange.com Subject: Re: Automating data from AS/400 to Microsoft Access. Don, Do you know if Lotus 1-2-3 or Lotus Approach can do this? We have the HTTP server on the AS/400 and this sounds WAY COOL. Glenn Gundermann Ronald A. Chisholm Limited Toronto Don Schenck wrote: > :::Don, > ::: > :::O.K. I'll bite.....how do you put AS/400 data into an Excel spreadsheet > :::using only RPGLE. > > Weeeeeeeeeeell ... it's about time someone asked! <g> > > Okay; I DID conveniently overlook the fact that you need the HTTP server > running on your AS/400. > > But assuming that is the case: > > 1. Write a CGI program in ILE RPG to output a web page. Put a table -- ONLY a > table -- on the page. Into that table you put the values you want to be put > into Excel. > > NOTE: You can embed EXCEL FORMULAS in your web page table! That's right! You > can put the literal "=SUM(B2:B99)" in your table on your web page, and Excel > will import it as a formula and perform the formula. Combine this with > custom-written formulas (in VBA) and you can really go to town. > > 2. Create an *.IQY file for use by the Excel Web Query feature. What's that? > You don't know how to do that? It's quite easy. I'll post an example here if > anyone is interested. > > 3. Run the web query you have defined in the file from step number two, above. > To do that, go to the Excel menu "Data|Get External Data|Run Web Query...". > > 4. Sit back and marvel; you have just used an RPG program to squirt data into > an Excel spreadsheet! > > IF you have HTTP server running on your AS/400, I can think of NO reason why > you shouldn't at least do this once; if for no other reason than to learn and > get excited about this. The possibilities are endless. > > This is yet ANOTHER reason to make the leap to ILE. > > ******** NOTE NOTE NOTE ********* > > This knowledge comes from Roger Pence, who showed this to me recently. In fact, > Roger has a sample CGI program that can easily be adapted. It can be downloaded > from www.The400Group.com and navigate your way, beginning at "Publications". > > THANK YOU ROGER! > > Peace, > > -- Don Schenck > www.SchenckTech.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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.