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 |
|
abuhassan
105 Posts |
 Posted - 2006-06-14 : 11:41:26
|
| hi i wanted to export a table with all the results in it into a csv file...is there any script that i can use to achieve this? |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-06-14 : 11:58:36
|
| You can use bcp...http://www.sqlteam.com/item.asp?ItemID=4722Ryan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-14 : 12:33:51
|
| 1. QA->Tools->options->results->results o/p format->CSV2. ctrl+shift+F3. select * from tablename------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Exporting a table in CSV format