Re: Transferring Data from Old Database to Excel File Using SQLPLUS

You can use SQL*XL to transfer your Oracle data (or any other database data) into Excel.

Find out about SQL*XL at www.oraxcel.com

With SQL*XL you can execute queries directly from within Excel. It pulls the data directly into your spreadsheet without the need to go via comma separated files etc.

To automate things you can make a SQL file. You can execute multiple SQL commands at once. If you want each table to go into a different tab e.g. you could execute the commands:

	select * from emp to sheet1!A1;
	select * from dept to sheet2!A1;
	etc

If you have a lot of data to retrieve you can collect each table in a different spreadsheet. SQL*XL can binary write a new XLS file. This is very very quick.

Best regards, Gerrit-Jan Linker
Linker IT Consulting Limited
www.oraxcel.com Received on Sun Jun 13 2004 - 09:54:36 CEST