Post reply

Import Data From Excel File

  • 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

  • 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]

  • February 23, 2014 at 4:18 am

    #1691357

    Thanks for your useful link.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply