I would like to know how to automate the following two processes with excel:

1. I would like to take data that is obtained from sql server 2000 queries
results and load the detail data onto excel spreadsheets.

2. I would also like to take data that is obtained from sql server 2000
query results and load the data in pivot tables in excel spreadheet 2003.

Thanks!