Results 1 to 4 of 4

Thread: Query output to a File

  1. 10-18-2008, 02:37 AM #1
    ismailr
    ismailr is offline Registered User
    Join Date
    Oct 2008
    Posts
    2

    Query output to a File

    Hi,

    Can someone help me to ge the output of a sql statment to a excel file directly instate of using the export fuction.

    thanks in advance.
    Reply With Quote Reply With Quote
  2. 10-18-2008, 02:02 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Use bcp, books online has syntax and sample code.
    Reply With Quote Reply With Quote
  3. 10-19-2008, 12:08 AM #3
    ismailr
    ismailr is offline Registered User
    Join Date
    Oct 2008
    Posts
    2
    thank for the reply.
    I very thankful if could forward the link.
    thanks
    Reply With Quote Reply With Quote
  4. 10-19-2008, 06:49 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Books online is installed on sql server and client machine by default.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules