I would like to update selected records in a Sql server table from an MS Excel spreadsheet using DTS. I tried to do this using Transfrom Data Task but it only lets me select data from excel. It does not let me write a update query. I could bring the data into a temp table in sql serer and then perform the update but I would prefer not to create the temp table.
Is there a way I could perform the update without the temp table?
Thanks!
Is there a way I could perform the update without the temp table?
Thanks!