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 |
|
brendalisalowe
Constraint Violating Yak Guru
269 Posts |
 Posted - 2004-08-04 : 13:22:25
|
| I need to take data from a table in SQL Server and put it into an Excel spreadsheet, but I want to be able to do it automatically without using DTS. How do I use linked servers to do that? What coding would I use? How do I set up the linked servers? Any help would be VERY much appreciated. Thanks!Brenda |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-04 : 13:35:48
|
| DTS is the way to go for Excel. You can do it automatically still using DTS. You can launch a DTS package from a job or from an application using dtsrun.exe.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-08-04 : 16:22:56
|
| Or you can create a view that looks like a csv file and bcp it out...wish we could bcp out sprocs....Brett8-) |
|
|
|
|
|
|
Linked Servers...HOW?