Wendy
Take a look here
http://www.nickhodge.co.uk/gui/datamenu/importexternal.htm
same can be used for PTs
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT[ at ]zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"Wendy Elizabeth" <WendyElizabeth[ at ]discussions.microsoft.com> wrote in
message news:D37C7664-FDAA-4794-A7AF-5EC937A251D3[ at ]microsoft.com...
[Quoted Text] >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!
|