excel programming

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
I would like to know how to automate the following two processes with excel:
Click to expand...

Have you tried the newsgroup microsoft.public.excel.programming? This is
microsoft.public.excel.charting.
 
HI Wendy,

In Excel 2003...
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.
Click to expand...

Data -> Import External Data -> New Database Query
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.
Click to expand...

Data -> Pivot Table and Pivot Chart Report -> External Data

In both cases, choose New Data Source and select SQL Server as the data
source.
If you need more details, see my Pivot Table tutorial (goes through the
steps needed to connect to an Access db, but SQL Server is much the same)
http://www.edferrero.com/ExcelTutorials/PivotTableTutorial2003/tabid/89/Default.aspx

Ed Ferrero
 
Back
Top