Hello Excellers

I am looking for an example of how I can run a DTS (Data Transfer Service) from SQL Server 7.0 to a MS-Excel 97 workbook.

Or is it easier to have a query that gets what I want out of the table, which is all what is in that table?

Thanks for any pointers.