RE: Oracle to Excel

[Burton, Laura L.]

Title: Oracle to Excel

Thank you so much!!  This works like a charm.    Laura   -----Original Message----- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 07, 2002 6:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to Excel   Laura,   Sorry about that - instead of using chr(10), use chr(09).   (10) is line feed.  (09) is tab.   also - don't forget to : set trimspool on - it gets rid of trailing spaces!   good luck!   Tom Mercadante Oracle Certified Professional -----Original Message----- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 06, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to Excel 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):   53-041-02                                                                                                                                                                                               0 2 AL POWER CO                                                                                                                                                                                              51271 27-Nov-01 173.52 447-57                                                                                                                                                                                                   D412                                                                                                                                                                                                     173.52 226 DONNELL                                                                                                                                                                                              43000 00014.04.D412                                                                                                                                                                                                                                                                                           It looks like it thinks it is a carriage return instead of a tab.  Any ideas?    Laura   -----Original Message----- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 06, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to Excel   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 Oracle Certified Professional -----Original Message----- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 06, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Oracle to Excel I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet.  We now have a need for this.  Could anyone enlighten me? Thank you in advance. Laura