exporting data to excel from my database

开发者_如何转开发

i need to export my sql-server database to an excel file between day x and day y ( i have a field in my database that contains the date ) . How can i do so ?

---

If you have 2005 or 2008 version you can use Integration Services. Here you can find video how to export data to excel with Integration Services. And here is example how to import from excel.

If you have prior version of MS SQL you can use Data Transformation Services.

---

• SO search yields the following question:

C# export to excel from sql server

• Google search yields the following article:

http://www.mssqltips.com/tip.asp?tip=1202

Filtering posts by date can be accomplished by for instance a view or a query gettings the desired posts

Search is your friend

EDIT:

• Also, someone posted the same problem on another site

http://www.eggheadcafe.com/community/aspnet/2/10102953/export-data-from-sqlserver-to-excel.aspx