SQL Query dump to Excel

16 Sep 2005 1:24 AM

Joe Smith

I have a SQL Query which I would like to have run and populate an Excel
Sheet everytime Excel opens a document. Anyone know what the best way to
do this?

Thanks.

16 Sep 2005 1:40 AM

Tom Moreau

You can use DTS to create a Data Pump from a SQL Server source to an Excel
destination.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..

"Joe Smith" <joesm***@aol.com> wrote in message
news:eGpLn1luFHA.2568@TK2MSFTNGP15.phx.gbl...

I have a SQL Query which I would like to have run and populate an Excel
Sheet everytime Excel opens a document. Anyone know what the best way to
do this?

Thanks.

16 Sep 2005 8:40 AM

Jose G. de Jesus Jr MCP, MCDBA

you can you excell to connect to a sql server sp or view

excel>data>get external data> new database query

--
thanks,

------------------------------------
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787

Show quote

"Joe Smith" wrote:

> I have a SQL Query which I would like to have run and populate an Excel
> Sheet everytime Excel opens a document. Anyone know what the best way to
> do this?
>
> Thanks.
>
>
>