sql server to excel

Last Post 07 Nov 2011 07:25 AM by dbandee. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Informative
jai
New Member
New Member

--
18 May 2011 02:22 AM
Hai All,

I am new to SQL SERVER.  I need to export data from sql server 2005 to excel on a daily basis in different sheets or different files without using SSIS. The file name should contain the date and time of the day on which it is generated. If any one knows the script for this please post it.
rm
New Member
New Member

--
18 May 2011 04:48 AM
You can use bcp to dump data to .csv file, books online has syntax and sample code.
dbandee
New Member
New Member

--
07 Nov 2011 07:25 AM

we use bcp, check the link below
http://social.msdn.microsoft.com/Fo...998e266363

you can also have ssrs report email me excel file daily, it would do the export for you

you may want to look into third party tools also.



Acceptable Use Policy
---