Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-12 : 18:53:47
|
| HS writes "Hi,I want to know method(s) to export SQL data in a csv/xls file.The idea is to redirect sql query output in another file(any format which is easily legible).I know in oracle u can use spooling to do so but don't know the same in SQL Server. Further, I want to automate execution of SQL query daily, get its output in a file and get it mailed daily to a group of people.Is it possible using SQL Server?Thanks and Best RegardsHS" |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-09-12 : 19:09:26
|
quote:
Originally posted by AskSQLTeam
HS writes "Hi,I want to know method(s) to export SQL data in a csv/xls file.The idea is to redirect sql query output in another file(any format which is easily legible).I know in oracle u can use spooling to do so but don't know the same in SQL Server. Further, I want to automate execution of SQL query daily, get its output in a file and get it mailed daily to a group of people.Is it possible using SQL Server?Thanks and Best RegardsHS"
You can use Data Transformation Services (DTS) for this.You can read about DTS in SQL Server Books Online.CODO ERGO SUM |
 |
|
|
|
|
|
How to Spool SQL data