dbTalk Databases Forums  

How to write to predefined excel file with DTS?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How to write to predefined excel file with DTS? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mikko Rantonen
 
Posts: n/a

Default How to write to predefined excel file with DTS? - 01-13-2005 , 02:46 AM







Hi!

I have e excel file that has two sheets and both sheets have text on them.
There is text placed on few first rows of these sheets.

I want to place data that comes from a strored procedure at the bottom of
these sheets. How can I do that? I know I can easily place data on an empty
sheet. But how can I place data on a sheet that already has text on few
columns?


Tanks,

Mikko



Reply With Quote
  #2  
Old   
Billy
 
Posts: n/a

Default Re: How to write to predefined excel file with DTS? - 01-13-2005 , 03:11 AM






I would recommend you to create a macro which will call dts which will
fill empty sheet and then that macro will move data from that new sheet
to bottom of the existing sheet.

HTH
Billy


Reply With Quote
  #3  
Old   
Mikko Rantonen
 
Posts: n/a

Default Re: How to write to predefined excel file with DTS? - 01-13-2005 , 03:42 AM




That's a good way too. But I wanted to know if it is possible to write that
data to a certain cell in excel sheet. With vbscript perhaps?

Thanks,
Mikko

"Billy" <abil2y (AT) yahoo (DOT) com> wrote

Quote:
I would recommend you to create a macro which will call dts which will
fill empty sheet and then that macro will move data from that new sheet
to bottom of the existing sheet.

HTH
Billy




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.