Update SQL table from Excel data

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.
Who is Participating?
Gary DavisConnect With a Mentor Dir Internet SvcsCommented:
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
eseincAuthor Commented:
I think I have it figured out using DTS, thanks for the input though.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.