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-18 : 16:43:47
|
| Hi Experts,I have imported data from an Excel Sheet using a SQL linked server. My question is : How can i have the table in SQL updated as soon as the excel Sheet is updated ?Thanks Guys |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-18 : 18:46:34
|
quote:
Originally posted by korssane
Hi Experts,I have imported data from an Excel Sheet using a SQL linked server. My question is : How can i have the table in SQL updated as soon as the excel Sheet is updated ?Thanks Guys
There is automatic replication features for it. you have to create SSIS package to check whether insert or updates and schedule with SQL jobs to synchronize. |
 |
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-02-18 : 21:30:57
|
| hi ,thanks for your reply. Do you have any links for SSIS package creating and SQL synch ?thanks |
|
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-02-18 : 21:37:00
|
| HI ,is there another way to do this cuz i am runnin the SQL Express 2005 free edition .thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-18 : 21:51:34
|
quote:
Originally posted by korssane
HI ,is there another way to do this cuz i am runnin the SQL Express 2005 free edition .thanks
You can use Bcp,Linked server or Opendatasource then. |
|
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-02-18 : 22:32:00
|
| HI sodeep,thanks for your quick reply. Actually i am using linked server to import excel data. The Excel data is chaniging every day and i want to know how to update the data from excel to sql table every time using the exsisting linked server..Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-18 : 22:35:23
|
| This one is here to support you:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 |
|
|
|
korssane
Posting Yak Master
104 Posts |
Posted - 2009-02-19 : 10:09:12
|
| thanks Sodeep. |
|
|
|
|
|
|
Basic question concerning Excel data import to SQL