Update Part Info from a list in Excel

unknown

We need to update our part leadtimes. We have developed a simple list in Excel, with the Part ID in the first column, and the desired Planning Leadtime in the second column.

I'm having a difficult time finding a technique for transferring a list like this from Excel to the database. I would need to lookup each part ID in the PART table, then replace the current PLANNING_LEADTIME for that part with the new value.

Any suggestions?

[Updated on 5/22/2013 6:29 PM]

unknown

Assuming the database you're using is Microsoft SQL Server, do this:

Save Excel document as .xls file type (.xlsx requires additional data connectors for SQL that may not be installed)

Ensure that you’ve added column headers in your Excel file. (such as PART_ID and LEADTIME)

In SQL Management Studio, import the file into a table such as tmpLEADTIME

Then run an update query like this in SSMS:

UPDATE PART

SET PLANNING_LEADTIME = tmpLEADTIME.LEADTIME

FROM PART INNER JOIN

tmpLEADTIME ON tmpLEADTIME.PART_ID = PART.ID

0911060553270289.pdf