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.
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.