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 |
|
Todd2006
Starting Member
18 Posts |
 Posted - 2009-02-23 : 23:12:57
|
| hello,I have table in sql server 2005 which has some points.I will be getting a file in excel which will have some test scores what I have to do is do some calculations and use the data from the sql table and then find the score and update the excel file.Can someone tell me how I can make this happen and how should I proceed with it |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-02-24 : 01:59:11
|
| Create a linked server with excel file and update the excel file with your calculations.See this - http://support.microsoft.com/kb/306397Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
excel and sql