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.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.|||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 :)
No comments:
Post a Comment