如何在Sqlserver2008R2中将Sqlserver表数据导出到excel表

我在sqlserver2008中有一个表名为customer并且每天都会插入记录。所以我想使用带有Scheduler的storedprocedure将所有数据导出到excelsheet。



请告诉我解决方案，



提前致谢

Hi,

I have one table in sqlserver2008 that table named "customer" and records are inserted daily basis. So I want to export all data's to excelsheet using storedprocedure with Scheduler.

Please let me know solutions,

Thanks in advance