<div>
You could use Reporting Service subscriptions:<br />
<a href="http://msdn.microsoft.com/en-us/library/ms159762.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms159762.aspx</a><br />

</div>


You could use Reporting Service subscriptions:
http://msdn.microsoft.com/en-us/library/ms159762.aspx [http://msdn.microsoft.com/en-us/library/ms159762.aspx]


<div>
John,<br />
<br />
Any Luck?<br />
do you need more help?<br />
<br />
Jason
</div>


John,

Any Luck?
do you need more help?

Jason

<div>
Hello Jason,<br />
I have been working on it. &nbsp;I don't have a solid solution for it ye. &nbsp;Had something else that came up that has taken most of my time. &nbsp;I am going to look at SQLCMD a little more. &nbsp;I would just like a straight dump to Excel from a MS SQL stored procedure.<br />
<br />
John
</div>


Hello Jason,
I have been working on it.  I don't have a solid solution for it ye.  Had something else that came up that has taken most of my time.  I am going to look at SQLCMD a little more.  I would just like a straight dump to Excel from a MS SQL stored procedure.

John

<div>
Thanks forthe help. &nbsp;I like the build export to excel solution. &nbsp;I don't want to use reporting services becasue we are using Crystal Server and I also want to have them &nbsp;run a solution and go right to excel. &nbsp;These are for mostly automated processes.<br />
<br />
Thans.
</div>


Thanks forthe help.  I like the build export to excel solution.  I don't want to use reporting services becasue we are using Crystal Server and I also want to have them  run a solution and go right to excel.  These are for mostly automated processes.

Thans.

<div>
<div class="content wysiwyg-content">
Hello, &nbsp;is there a way to automatically have the results from a MS SQL query get expoerted directly to Excel? <br />
<br />
To take it one step further I have a number of scripts that users need to have run every morning or some even just every Monday and I would like to be able to set them up so they automatically fire off and save the results to an Excel spreadsheet in a specific directory with a file name. &nbsp;Is this possible in SQL?<br />
<br />
Thanks,<br />
John
</div>
</div>


Hello,  is there a way to automatically have the results from a MS SQL query get expoerted directly to Excel? 

To take it one step further I have a number of scripts that users need to have run every morning or some even just every Monday and I would like to be able to set them up so they automatically fire off and save the results to an Excel spreadsheet in a specific directory with a file name.  Is this possible in SQL?

Thanks,
John

Exporting MS SQL results directly to Excel

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.