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 |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2006-12-26 : 16:02:36
|
| HiI'm using SQL Server 2005 and was wondering if there is a command so I can spool out a table into Excel 2003 (without using the results to file option)The issue is that I have a large number of tables which I need exported to Excel so am trying to look for a simple script to do this, which can be incorporated into a SP.Also, I connect via Windows Authentication (so there is no sa or pwd)Many thanks! and Merry Christmas |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2006-12-27 : 15:36:05
|
| Apologies, but does anybody have any answers to this question?I just want a simple (if available) line(s) of script which I can incorporate into an SP to display the results of a table in an Excel file.Any help would be received gratefully!Thanks! |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-12-28 : 11:57:35
|
| dnf,What Michael was saying was that you should post a single message in a single forum, and follow that message's responses to get your answer. It saves you the effort of monitoring both places, and avoids wasting the time of someone who answers your question in one forum only to find it's already been answered in a different one.In response to your question, look here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926Ken |
|
|
|
|
|
|
SQL Server 2005 Export to Excel 2003 command....