Hi, Did you try "set wrap off" I tested the below script and it is working... set wrap off set lines 5000 spool out1 select * from <TABLE_NAME> where rownum < 2 ; spool off Thanks, Anurag On Wed, Jun 11, 2008 at 6:27 AM, Rick Ricky <ricks12345@xxxxxxxxx> wrote: > I am running a query to dump some rows and I made the rows comma delimited > like this > select col1||','||col2||','|| .... > from table > > I set lines 5000. > > I want to spool it so the spool file does not wrap. This way I can load the > data into excel. The data keeps wrapping and when i import it, I get it > wrapped in excel. its alot of columns. lines 5000 should be sufficient. I > just don't have enough screen space for it all. > -- Anurag Verma, Database Administrator ERCOT(Electric Reliability Council of Texas), Texas 76574