Update SQL table from Excel data

Posted on 2012-08-23
Last Modified: 2012-08-23
I have a column in a SQL table that I need to update with some pricing information on certain items in the table. The pricing updates are contained in an Excel spreadsheet. I'm not to expierienced with SQL but it looks like there are several ways to do it. DTS, OLEDB.

Can someone help me with SQL syntax or provide some insight on the best way to accomplish this?

Table Name - IV00103
Column - Last_Originating_Cost (updated via Cost column from spreadsheet)

I only want to update items where the SQL column itemnmbr matches the item number column in the spreadsheet.
Question by:eseinc
    LVL 18

    Accepted Solution

    Check out the NuGet package LinqToExcel if you are using DotNet to read the spreadsheet as a datasource (with Linq) and then update your Sql table.

    Gary Davis

    Author Comment

    I think I have it figured out using DTS, thanks for the input though.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how the fundamental information of how to create a table.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now