This discussion is archived
1 Reply Latest reply: Feb 7, 2013 6:09 AM by Jeff Smith SQLDev PM RSS

Why spool doesnt work for me?

989775 Newbie
Currently Being Moderated
Hi,
I just start to use SQL Developer and everyday i have several routines like export all data to XLS files, clear colums, reset values and etc.
So i start to search for comands that will do all this but i cant make one of them work
This one it's for export a Table to a excel file and i'm using spool

Spool c:\TABLE.xls
Select * from DATATABLE;
Spool off

the comand creates the TABLE.xls but it has nothing on it, i have search the internet and try some solutions, and none of them have worked,
can anybody help me?

i'm using sqldeveloper 2.1.1.64
  • 1. Re: Why spool doesnt work for me?
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    Spool will create a text file, so while your file will be created with the XLS file extension, it's just going to be a flat text file. If you want an Excel file, you'll need to use the SQL Developer Grid, Export -> Excel feature. I believe there are some folks that have built db packages that can create xls files, so you could try looking for those if you wanna stay in the script/SQLPlus world.


    Also, your version is very out of date. Can you upgrade to v3.2 and try again?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points