Import Data From Excel File

• shohelr2003

  Hall of Fame

  Points: 3535

  More actions

  February 21, 2014 at 9:17 pm

  #289860

  Dear,

  I have a table with 3 columns (Id, Name, Dept). The table has more than 1000 rows. After entering these information, I have added another column "Salary". From an excel file where there are only two columns (Id, Salary), I want to import data to sql server database.

  Is it possible to match "Id" between excel file and sql server table and thus update "Salary" column against that "Id"? I have tried using Sql Server Import and Export Wizard, but it inserted additional rows to the table containing "Id" and "Salary".

  Please help me by providing any idea.

  Thanks

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  February 22, 2014 at 2:48 pm

  #1691345

  You may find what you are looking for in the following:

  http://support.microsoft.com/kb/321686

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• shohelr2003

  Hall of Fame

  Points: 3535

  More actions

  February 23, 2014 at 4:18 am

  #1691357

  Thanks for your useful link.