Re: Oracle7 data to Excel, xBase, etc.

From: <air1wdg_at_airvax.air.ups.com>
Date: 1995/07/01
Message-ID: <1995Jul1.031742_at_airvax.air.ups.com>#1/1


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
>

        Hi Jeff,

        I am an Alumni of UCF Class of '78 BSE program.

	I am familiar with a couple of ways that are very
	easy.  They are not however cheep.  Both eaisy ways 
	involve SQL*Net on both the Oracle RDBMS server and
	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.  With the pieces above
	in place, almost any front end PC tool will talk to the
	ODBC driver and create a result set. 
	
	MS-Query
	ACCESS
	EXCEL
	etc...

	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.

	I hope the above has helped.  You can reach me at my address
	below if you have any other questions...

	Regards...Danny Green 
Received on Sat Jul 01 1995 - 00:00:00 CEST

Original text of this message