Import data from excel into SQL

[aaa8888]

Hi, i'm trying to import a column from my spreadsheet into a table in sql. I have two columns in my spreadsheet "service tag" and "warranty info". The table in sql has many columns or fields and one of that field is the same as my spreadsheet "service tag". I'm trying to import the column "warranty info" into the sql table that matches the field "service tag". Any help or suggestion would be great. Thanks

 

[jhall01]

try importing into a temp table then run an update statement that is joined on "service tag" from the temp table to the table you are trying to insert into

 

[gradley]

You should be able to do this directly with a Transform Data Task. You can map the fields you want within this task as long as the fields are compatable. If not, you can use the ActiveX script within the Transform Data Task to make them compatible.

If you are trying to update existing records, you can do this with the Data Driven Query task.