|
|
|
Author |
Message |
SandiB
|
Posted: Fri Dec 23 14:47:40 CST 2005 |
Top |
SQL Server Developer >> export a query to Excel
Hi all,
Is there a way to export the results of a query to an Excel file?
I need to create a report in a Stored procedure and I want it to email an
excel file to a group. I know how to create the email and attach the file,
but I dont know how to Automatically create the file thru my Sproc.
TIA,
Joe
SQL Server113
|
|
|
|
|
Johnny
|
Posted: Fri Dec 23 14:47:40 CST 2005 |
Top |
SQL Server Developer >> export a query to Excel
Not sure how others do it, but I create a DTS package and then execute the DTS
package from a SP using xp_cmdShell
exec master.dbo.xp_cmdshell "DTSRun /S gic042a /U xx /P xxxxx /N
Scorecard_Monthly_Imports"
Be interesting to see how others do it.
j
-- Posted with NewsLeecher v3.0 Beta 6
-- http://www.newsleecher.com/?usenet
|
|
|
|
|
jaylou
|
Posted: Tue Dec 27 07:02:01 CST 2005 |
Top |
SQL Server Developer >> export a query to Excel
Thank you. That's a very good idea. All I need to do is add a dateStamp to
my file name for history.
Thanks,
Joe
> Not sure how others do it, but I create a DTS package and then execute the DTS
> package from a SP using xp_cmdShell
>
> exec master.dbo.xp_cmdshell "DTSRun /S gic042a /U xx /P xxxxx /N
> Scorecard_Monthly_Imports"
>
> Be interesting to see how others do it.
>
> j
> -- Posted with NewsLeecher v3.0 Beta 6
> -- http://www.newsleecher.com/?usenet
>
|
|
|
|
|
John
|
Posted: Tue Dec 27 08:40:01 CST 2005 |
Top |
SQL Server Developer >> export a query to Excel
Hi
Check out http://www.sqldts.com/default.aspx?200
John
> Thank you. That's a very good idea. All I need to do is add a dateStamp
> to
> my file name for history.
>
> Thanks,
> Joe
>
>
>> Not sure how others do it, but I create a DTS package and then execute
>> the DTS
>> package from a SP using xp_cmdShell
>>
>> exec master.dbo.xp_cmdshell "DTSRun /S gic042a /U xx /P xxxxx /N
>> Scorecard_Monthly_Imports"
>>
>> Be interesting to see how others do it.
>>
>> j
>> -- Posted with NewsLeecher v3.0 Beta 6
>> -- http://www.newsleecher.com/?usenet
>>
|
|
|
|
|
Thomas
|
Posted: Sun Jul 15 15:10:01 CDT 2007 |
Top |
SQL Server Developer >> export a query to Excel
Check out www.sqlscripter.com.
It's free.
> Hi all,
> Is there a way to export the results of a query to an Excel file?
>
> I need to create a report in a Stored procedure and I want it to email an
> excel file to a group. I know how to create the email and attach the file,
> but I dont know how to Automatically create the file thru my Sproc.
>
> TIA,
> Joe
|
|
|
|
|
|
|