Re: Oracle7 data to Excel, xBase, etc.

From: Simon Thompson <scthomp_at_ibm.net>
Date: 1995/07/09
Message-ID: <3tn6i6$15bl_at_news-s01.ny.us.ibm.net>#1/1


In message <1995Jul1.031742_at_airvax.air.ups.com> - air1wdg_at_airvax.air.ups.com writes:
:>
:>In article <3s9jf4$32c_at_longwood.cs.ucf.edu>, hays_at_longwood.cs.ucf.edu (Jeffrey Hays) writes:
:>> Does anyone have any suggestions for the easiest was to make .wk1 (excel)
:>> files from an Oracle 7.1 database.
:>> hays_at_longwood.cs.ucf.edu
:>>
:> on your PC. The PC also needs to have ODBC for OracleX
:> (6 or 7). This ODBC driver is an Oracle supplied product
:> and is free if you have SQL*Net.
 

:> The second way, which is cheep but not as generic and
:> requires much more understanding of SQL and the way
:> Oracle SQL*Plus works is to build a fixed column width
:> fixed record length file with a query in SQL*Plus on
:> your Oracle RDBMS server machine, copy the file to your
:> PC and load the file with Excel (because Excel does this
:> easily). Then output the file in your desired format.

Another wasy is to use the Oracle Browser (Discoverer/2000). From Browser, you can export to a variety of formats.



Simon Thompson
Christchurch
New Zealand Received on Sun Jul 09 1995 - 00:00:00 CEST

Original text of this message