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

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

"vt" wrote:

>
> Hi
>
> You can use DTS.
> for more information http://www.sqldts.com/
>
> Regards
> VT
> Knowledge is power, share it....
> http://oneplace4sql.blogspot.com/
> "Wendy Elizabeth" <WendyElizabeth@discussions.microsoft.com> wrote in
> message news:EA3C298B-ADAF-45BE-BC0E-035177244F9A@microsoft.com...
> >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!
>
>