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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Spool table out to Excel - help!

Author  Topic 

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2006-12-26 : 15:56:21
Hi

I'm using SQL Server 2005 and was wondering if there is a command so I can spool out a table into Excel (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.

Many thanks! and Merry Christmas!

Dave

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-12-26 : 16:34:00
Doe not cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76839

CODO ERGO SUM
Go to Top of Page
   

- Advertisement -