sql server to excel

Last Post 07 Nov 2011 08:25 AM by dbandee. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
jai
New Member
New Member

--
18 May 2011 03: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 05: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 08: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.

You are not authorized to post a reply.

Acceptable Use Policy