从Excel更新SQL表 [英] Update sql table from excel

问题描述

我需要有关查询的帮助以从excel更新sql中的现有表.我在sql中有数据表，并且每周都会收到一个Excel文件.在那个excel文件中是有关标题，街道变化的数据...，我需要在sql中找到一个匹配项并进行更新.有人可以帮忙吗?谢谢's

Hi,
I need help about query to update existing table in sql from excel. I have table in sql with data, and I am receiving every week one excel file. In that excel file are data about changes in title, street ... and I need to find a match in sql and update. Can anyone help? Thank''s

推荐答案

尝试此链接会有所帮助:-

try this link will be helpful:-

16,000,000 results on update sql table from excel

Always search google first.

这篇关于从Excel更新SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！