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 |
|
korssane
Posting Yak Master
104 Posts |
 Posted - 2009-02-19 : 21:47:20
|
| Hi Guys,I am new in SQL. Actually i am using Linked server to import Excel data into SQLServer 2005 data table. I successfully created the link and imported the data. The problem is : i do not know how to update the SQLServer table automatically (for example, every day at 6:00PM using my linked server )?Please, any help will be greatly appreciated.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-19 : 22:51:23
|
just use likeUPDATE tSET t.col1=s.col1,...FROM table tINNER JOIN Excelname...Sheetname sOn s.PK=t.PK Pk is column by which table and excel are relatedhttp://support.microsoft.com/kb/306397 |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 22:52:07
|
| Schedule with a job. I suppose you said in other thread you hav express edition. It doesn't have SQL Agent. |
|
|
|
|
|
|
Update SQLServer table from a linked server