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 |
|
arv_rehal
Starting Member
4 Posts |
 Posted - 2009-06-14 : 10:53:07
|
| Hi All,I have one existing file in SQl Server with 10000 records in it, I need to import data from Excel file but i need to check every record whether it exist in SQl or not if not then import it and if yes then show me the old value field by field along with new values from excel, if i found that value need to change then change otherwise keep the old value. Can any one help me in writing the script.Thanks.Arvinder |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-06-14 : 11:13:15
|
| Import Excel into temp table and Check it with IF exists or Not Exists,Except or Left join. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-14 : 13:22:42
|
But there is no way to have some kind of a dialog to decide which data is to store by having a look at it.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Importing from Access