SQLTeam.com | Weblogs | Forums

Updating SQL tables values with Excel

Hi All,

I have a customer table which requires some elements of data updating, I have been handed a excel spreadsheet which includes all of the customers, and the columns that are missing data (including the customers unique ID which I thought would marry the two up).

When trying to import through SSMS instead of updating existing values it simply creates new rows?

Import the excel into a new table and use the new table by mapping it with actual table on uniqueId column and update the required columns.