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-13 : 09:56:12
|
| Jensen writes "How do I make use of bulk copy program (bcp)in MS SQL 6.5 to take in my query and export the data to a MS Excel File/format?" |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-05-14 : 05:13:49
|
| If I remember correctly, in SQL 6.5 you couldn't copy data directly from a query with bcp as you can in SQL 2000. You need to use either a view or a temporary table to store the desired recordset.bcp ##temp_authors out temp_authors.txt -c -Sservername -Usa -PpasswordLook at the arguments for bcp in BOL, to determine the best way to delimit the columns. Excel should have not problems reading a CSV file. |
 |
|
|
|
|
|
Export Data To MS Excel File