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 |
arorarahul.0688
Posting Yak Master
125 Posts |
Posted - 2009-05-26 : 05:46:00
|
Hi Eevryone,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.meansSheet1 (Specific Format data) -> in Form of TABLE in SqlServer--- |Updated resultant data in Excel Sheet2 (Specific Format data)<--|thanks,Rahul |
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-05-26 : 05:51:11
|
go to query--> result to --> result to file (ctrl+shift+f) then execute the query then u can save the file in excel sheet |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 05:51:43
|
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. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|