dbTalk Databases Forums  

how can i read/write data in to .xls

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


Discuss how can i read/write data in to .xls in the microsoft.public.sqlserver.dts forum.



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

Default how can i read/write data in to .xls - 06-13-2006 , 05:51 AM






hi buddys,
I have a problem with writing data in to the excel using
vbscript.
i need to pick some part of the data from excel and write in to the
another excel sheet.
please any can help me in these.

with regards,
mohan babu.k


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

Default RE: how can i read/write data in to .xls - 06-13-2006 , 06:28 AM






Hi,

Your best bet would probably be to use the MS Excel objects library from
within vbscript. You would be able to open, create and manipulate
spreadsheets.

To use this on the server you would need the object library installed on the
server (MS Excel).

Can you use CSV?

Ray

"mohan_kasturi2000 (AT) yahoo (DOT) co.in" wrote:

Quote:
hi buddys,
I have a problem with writing data in to the excel using
vbscript.
i need to pick some part of the data from excel and write in to the
another excel sheet.
please any can help me in these.

with regards,
mohan babu.k



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.