Home » SQL & PL/SQL » SQL & PL/SQL » Export or import data with CSV file (6i)
Export or import data with CSV file [message #280350] Tue, 13 November 2007 05:19 Go to next message
ganesh_jadhav0509
Messages: 66
Registered: May 2007
Location: Chester
Member

Dear all,

I want to know how to export the data in excel file with the help of csv file.

Regards,

Ganesh Jadhav
Re: Export or import data with CSV file [message #280352 is a reply to message #280350] Tue, 13 November 2007 05:27 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
So you have a CSV file and you want to make it an Excel file? Where does Oracle come into play?

MHE
Re: Export or import data with CSV file [message #280373 is a reply to message #280352] Tue, 13 November 2007 06:17 Go to previous messageGo to next message
Littlefoot
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'll need to create a CSV file by selecting some values from Oracle database. The simplest way to do that would be spooling result of a SELECT statement into a file.

If you choose to use semi-colon (;) as a delimiter, and even use .CSV extension with the output file, MS Excel will not even ask you a thing, but open this file by default and put every column you've selected into its own worksheet column.
Re: Export or import data with CSV file [message #280376 is a reply to message #280350] Tue, 13 November 2007 06:27 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unloader: http://asktom.oracle.com/tkyte/flat/index.html

Regards
Michel
Previous Topic: Date Query
Next Topic: Fetch special datas of any table in a procedure with ref cursor
Goto Forum:
  


Current Time: Sat Aug 19 17:36:26 CDT 2017

Total time taken to generate the page: 0.04193 seconds