Can anyone please tell me, is there exists any process in sql server using which i can take data from one Excel sheet (Source) in a Table format in sql server, do some manipulations and then again feed the resultant data in a destination excel sheet in a specific format.
means
Sheet1 (Specific Format data) -> in Form of TABLE in SqlServer--- | Updated resultant data in Excel Sheet2 (Specific Format data)<--|
openrowset and ssis are two common ways to do this.
You could also control it from the spreadsheet using VB.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
Take and feed data in excel sheet using SqlServer
Posted - 05/26/2009 : 05:46:00
