Re: Oracle7 data to Excel, xBase, etc.

Oracle ODBC drivers are available through Microsoft or Oracle - the latter probably more up to date, but in either case effectively free. You would use this through the MS Query applet which is shipped with Excel 5.0 to build a query, then import the results into a Pivot Table in Excel.

Alternatively, you could buy a package from Oracle called Oracle Objects for OLE, which provides a programmable OLE interface with your database.  For each query you want to run, simply! write a quick Excel VisBasic routine to access this OLE object.

In either case, assuming your Oracle data is on a remote host, you will need to use SQL*Net to link the querying machine to the oracle based machine - i.e not your regular networking or host access package - and I think that this will cost you also.

You also mention xBase...if your requirement to bring data from both Oracle and xBase into the spreadsheet to play with, you might be just as well looking at the ODBC solution - it would mean that you could handle both types of data in the same way - through MS Query, which, although slower in the case of Oracle, might be a consideration if the users who need the data delivered will have trouble learning one method let alone two!

Jonathan Received on Thu Jun 22 1995 - 00:00:00 CEST