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
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 GreenReceived on Sat Jul 01 1995 - 00:00:00 CEST