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 |
|
oboy
Starting Member
1 Post |
 Posted - 2004-09-29 : 06:46:34
|
| I'm using a stored proc called from a DTS job to produce output for an XL file, the formats of the cells in XL strip leading zeros among other automatic formatting probelms. The output of the SQL in the proc has the correct format, how can I set the XL cell formats on the fly not to play around with what I'm feeding it? I also need to name the file on the fly with a datestamp which I can do by using destination file rather than XL and changing the file to XL by renaming the appendix as .xls. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2004-09-29 : 07:32:29
|
| You may find it easier exporting to a text file. What does the resultset from the sp look like?Mark |
 |
|
|
|
|
|
DTS SQL7 export to XL