Thank you for your response Tom. I received other responses as well, and
I know that I can comma delimit a .txt file but I wanted to know if I could do
it all at one time, which is why I tried your suggestion first. It works except that each field is in a
separate row instead of a column. Below is an example (1 record is shown):
It looks like it thinks it is a carriage
return instead of a tab. Any ideas? Laura -----Original Message----- Laura, lots of tools do this for
you automatically. Oracle discoverer will export the results of a query
directly into Excel format. You can do this yourself
as follows: in SqlPLus select
col1||chr(10)||col2||chr(10) from table. the chr(10) is the tab
character. spool the results to a
output.xls open the file using
excel. the tab character is the default column delimiter. You
should see all your data in cells. hope this helps. Tom Mercadante
|
Title: Oracle to Excel
- oracle to excel Markus Reger
- RE: oracle to excel Jamadagni, Rajendra
- Oracle to Excel Burton, Laura L.
- RE: Oracle to Excel Kevin Lange
- RE: Oracle to Excel Saira Somani
- RE: Oracle to Excel Mercadante, Thomas F
- RE: Oracle to Excel Rodd Holman
- Re: Oracle to Excel Jared . Still
- RE: Oracle to Excel Kevin Lange
- RE: Oracle to Excel Burton, Laura L.
- RE: Oracle to Excel Mirsky, Greg
- Re: Oracle to Excel Mark Richard
- RE: Oracle to Excel Johnson, Michael
- RE: Oracle to Excel Steve . Parker
- RE: Oracle to Excel Mercadante, Thomas F
- RE: Oracle to Excel Burton, Laura L.