RE: Oracle to Excel

[Burton, Laura L.]

Title: 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