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 |
|
hxm88311
Starting Member
2 Posts |
 Posted - 2008-07-09 : 16:21:49
|
| Hi, I'm using Microsoft SQL Server Management Studio 2005 and Excel 2003. I've imported the database table values to excel. But now I wanted to establish a connection between the two programs, such that when I update some number in the database, the values on excel will automatically update. Similarly, when I update values in excel, the values in database will automatically update as well. I'm not very much an expert on this at all, so I'll appreciate it if someone can tell me how I can accomplish this. Thank you!Shell |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-09 : 16:41:50
|
| You will have to create a package and schedule it regularly. |
 |
|
|
|
|
|
SQL to Excel