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-06-13 : 08:07:28
|
| Enough writes "Hi, The situation:I have a 100,000 record database, which I need to break up into 500 row record sets, which then need to be exported using DTS into an MS Excel file type. Does anyone know of a way I can automate this process? Thanks.Enough" |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-14 : 12:42:26
|
| Maybe with a whole lot of temp tables.. but I must ask why you would want to do such a thing?-----------------------Take my advice, I dare ya |
 |
|
|
|
|
|
Re: Using DTS to automatically export various ranges to different Excel Files