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 - 2005-09-23 : 07:38:20
|
| Sundari writes "Hi, How can i export data from sql server job to excel sheet? The data to be exported will be the result set of combining 3 or 4 tables . Thanks in advance. :)" |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-23 : 12:02:36
|
| DTS!------------------------I think, therefore I am - Rene Descartes |
 |
|
|
rheitzman
Starting Member
16 Posts |
Posted - 2005-09-23 : 16:45:33
|
| "sql server job" is pretty vague.By using Excel's Data, Import External Data... features you can easily extract data from databases.Or you can use Excel VBA to add some logic to the data retrival to do most anything you want.Excel does have a row limit (64K I think) so it can't be used for everything. You may also run in scale issues for big tasks. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
exporting data to excel