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 |
|
Wyatt70
Starting Member
6 Posts |
 Posted - 2005-03-02 : 13:24:53
|
| I have set up a package to export data to an Excel spreadsheet. The package gets the data to the appropriate Worksheet, but the data is entered immediately below the named Excel range in which I want to put the data.I'm using a Transform Data Task in which my SQL Server database is the source, and the Excel spreadsheet is the destination. I created a named range in Excel, and I found and selected that range when I configured the Transform Data Task. So why is this happening? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-03 : 06:19:04
|
| Hmm. Yeah, I've seen this before. I think it's when the sheet in excel has been used. If you copy in a fresh, empty .xls file that you can use as a template into whereever it needs to be before the extract then your data should end up in the correct place. But if you have any data in the sheet beforehand - even if it is then deleted - the export will output after the old data rows.-------Moo. :) |
 |
|
|
Wyatt70
Starting Member
6 Posts |
Posted - 2005-03-03 : 08:55:56
|
| Interesting. Thanks for the info, I'll try it out later today.In the meantime, what I ended up doing was to create a range of two rows. I hid the second row, and now I can make it look the way I want it to. |
|
|
|
|
|
|
Exporting to Excel