Re: How to convert oracle data to LOTUS readable format

             LOTUS produced its own "datalens" technology for doing exactly this from Oracle, dBase etc etc. It WAS available under DOS and UNIX.

             If you have client/server capability betwixt PC and whatever your Oracle runs on you could use any client/server browsing tool and exploit DDE (if your LOTUS is Windows based) LOTUS IMPROV uses Q+E.

             Failing that you're into intermediate files CSV being lowest common denominator. Getting Oracle into CSV is not easy - unless you have Oracle data browser or similar tool. Otherwise you have to write SQL scripts - a topic covered ad nausiam already.

             One other option is a product like MONARCH, that reads standard reports and outputs them in a variety of formats (including WRK) the advantage here being you don't have to write custom SQL-scripts. [The parse option in LOTUS 123 can do this to a limited degree but isn't flexible enough.]

             I guess it depends how much data, and how often you want to download it - and how much hassle you can tolerate.

   Damian Branigan       
   (Project Leader ISS)              "In this world who can do a thing will not
   d.branigan_at_brookes.ac.uk           And who would do it cannot, I percieve."
                                      RB


_______________________________________________________________________________