DTS Import Update table.

[raman.p123]

HI.. My name is Raman
I am the beginner in using DTS Import facility.

Can any one help me how to update the table while importing the Execl file using DTS import wizard
I 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.

[AJ2]

Selecting "Delete rows in destination table" of "Column Mappings" tab in "Column Mappings and Transformations " page will solve your problem. To get to this page click "..." below "Transform" in "Select Source Tables and Views" page.

[raman.p123]

No dear if i do like that.it will deletes all the rows and it will insert once aggain.i dont wont to do like that.just i need to update the table.
ok finally i come to know that there is no update table statement in DTS import option is it true??
ok any how thanx for u r replay byee..
Raman :)