Results 1 to 5 of 5

Thread: export data to Excel

  1. 11-17-2005, 11:53 AM #1
    sam17
    sam17 is offline Registered User
    Join Date
    Sep 2005
    Posts
    10

    export data to Excel

    Hi,
    can any help me in how to export data from sqlserver 6.5 to Excel sheet.
    Reply With Quote Reply With Quote
  2. 11-17-2005, 12:43 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Tried with data transfer service?
    Reply With Quote Reply With Quote
  3. 11-17-2005, 01:09 PM #3
    sam17
    sam17 is offline Registered User
    Join Date
    Sep 2005
    Posts
    10
    Can you please give me the steps to do with data transfer service.
    Reply With Quote Reply With Quote
  4. 11-17-2005, 03:08 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    I don't have sql6.5 box anymore, check books online for details.
    Reply With Quote Reply With Quote
  5. 11-17-2005, 03:44 PM #5
    sdives
    sdives is offline Registered User
    Join Date
    Nov 2002
    Location
    Chesapeake, VA
    Posts
    104
    I've never seen that capability with SQL Object Transfer in 6.5. The only way I've ever done an export to Excel from SQL 6.5 is by setting up an ODBC DSN to the server then using GetExternal data from within Excel.
    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