Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: can I export view result to excel ?

    Good morning all,

    I created a view that selects the rows of the records from a table that matches where condition.
    I need to export the records to excel so I could send it out....
    what is the best way to do?
    Please tell me detail, I don't know much about SQL 2000, still learning.

    Thank you,

  2. #2
    Join Date
    Oct 2003

    DTS wizard

    Use the DTS wizard (import and export data in start menu->Microsoft SQL server).

    The wizard will ask you the information needed in order to complete the operation. Select the MS-Excel driver as a destination (as well as the output filename), choose the first options (export tables an views) and select your view in particular.

    Shouldn't be too hard.

  3. #3
    Join Date
    Dec 2003


    yes, I was able to do that!
    Thank you!

Posting Permissions

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