And do not forget to use ... WHERE ROWNUM<65537 :-))) JP
On Monday 23 September 2002 15:13, you wrote: > Bob, > > All of the options stated by people from this list are excellent. > > One thing that was not mentioned was that Excel can read any type of text > file. It will notice that it is a text file, and will provide you with the > opportunity to declare what the column delimiter is. > > What this means is that you can use any character as a field delimiter, > tell Excel what that column is, and it will convert the file for you. > > By default, Excel likes the TAB char as a column delimiter. So, you can > write your query as such: > > select column1||char(10)||column2||char(10)||column3||char(10) from > table_name. > > Spool the output and name the file newfile.txt; start Excel, and file|open > the file and follow the help wizard. I do this all the time. > > Hope this helps. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Friday, September 20, 2002 4:33 PM > To: Multiple recipients of list ORACLE-L > > > All, > > Is it possible to create Oracle reports into Excel > format ? > Is it possible to spool Oracle tables into Excel > format? > > Thanks in Advance > Bob > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ ----------------------------- Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
