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 - 2002-05-07 : 09:58:29
|
| David writes "For Microsoft SQL 2000: Is there a way, command or SP, to have records in a table placed into a CSV or Excel file? Thanks." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-07 : 11:39:06
|
| Sure, you have 2 options. One is Data Transformation Services (DTS) that specifically transfers data from any source (not just SQL Server) to another format (not just SQL Server) You can use it to export SQL Server data into either a CSV text file or directly into an Excel workbook file.The other option is bcp, which only handles text files, but is very easy to use. It is a command line utility included with SQL Server.Both of these are well documented in Books Online, and you can also search SQL Team for more information on them as well. |
 |
|
|
|
|
|
Exporting records to a CSV or Excel format file