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 |
|
raman.p123
Starting Member
4 Posts |
 Posted - 2006-07-25 : 07:05:37
|
| HI.. My name is RamanCan any one help me how to update the table while importing the Execl file using DTS import wizardI imported an Excel Files that files having three records .I wont import once again same e file, which is modified in Excel file. Once I import one more files with same fields that should be updated. Instead of deleting or appending to the same table plz any one can help me in this regard.I am the beginner in using DTS Import facility. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-07-25 : 17:47:54
|
| Probably the easiest way to tackle this is to import your Excel data into a temporary (staging) table, then run a stored proc/script to update your live table.DTS can perform the first part of your task, but you'll need to write the second script yourself. DTS can run this script for you if you like. |
 |
|
|
|
|
|
By using DTS Import how to update the tables