Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    116

    Unanswered: Export query results to notepad

    Hi,\

    Is there any code or any way i can export the results of my query into a notepad file...

    lets say i do a select statement

    select * from dept

    How do i get the data exported into a notepad file?

    thankx in advance

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    use the spool command.


    spool c:\list.txt
    select * from dept;
    spool off



    then use notepad to open the file c:\list.txt
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Feb 2005
    Posts
    116
    thankx a lot mannnnn

    it works perfectly!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •