excel mapping

External Since: Jun 17, 2007 Posts: 19

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!

External Since: Jul 21, 2004 Posts: 1929

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.TakeThisOut@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"Wendy Elizabeth" <WendyElizabeth.TakeThisOut@discussions.microsoft.com> wrote in
message news:D37C7664-FDAA-4794-A7AF-5EC937A251D3@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!