Export Data - DTS SQL Server 2000
1. Open “Start > All Programs > Microsoft SQL Server > Import and Export Data”.
2. Choose “Data Source” : Microsoft OLE DB Provider for SQL Server.
Choose “Use SQL Server Authentication”.
Choose “Database” : example : Northwind.
Click “Next”.
3. Choose “Destination” : Microsoft Excel 97 – 2000.
...
For check the capture step by step, please follow the free download link below :
https://docs.google.com/open?id=0B6a5vK3IVP_0OTQxZDA2OTYtZWE1ZC00MWUwLTk5NzUtYzQ4NDg1NmFhNDRh