I am trying to update a table in my database by using an Excel sheet. I have done quite a bit of researching and seen that OPENROWSET might be the option I am looking for. I have looked on here for a forum that has a similar question, but I can't seem to find anything.
The Excel file would only be a few fields, item id and the price. I would then overwrite the price in the database with the one in the Excel sheet.