是否可以通过将数据与Excel文件进​​行比较来更新数据库中的现有值? [英] Is it possible to update existing value in database by compare data with Excel File?

问题描述

您好，所有专家，

我有一个数据库和一个Excel文件.在我的数据库中，我有1个表(已经有100行)，并且在此表中，有一个字段(AliasName)为空.因此客户想要从Excel文件中更新字段(AliasName).由于在excel文件中，他们输入了所有别名(100个别名).

我的问题是如何使用excel中的数据更新表中特定字段中的现有值?

注意:
-该表具有主键(代码")，并且excel也也包含此字段(代码").
-我们只用一张桌子.

谢谢

TONY

Hi all experts,

I have one database and one excel file. in my database, i have 1 table(it has 100 Rows already) and in this table, there is one field(AliasName) that null. So the customer want to update the field(AliasName) from Excel File.Because in excel file, they input all aliasname (100 alisname).

My question is How can we update existing Values in specific field in table by using data from excel?

Note:
-The Table has primary key ("Code") and excel also include this field too ("Code").
-We use only one table.

Thanks

TONY

推荐答案

我不确定这是否是您真正想要的东西，但是这里有一些链接供您查看:

链接1 [ ^ ]
链接2 [链接3 [ ^ ]

据我所知，在SQL Server 2000中，您可以将excel工作表导入数据库中的表(通过DTS)，然后从excel表中更新表，您也许也可以在2008年做到这一点.还要寻找它.

祝你好运，
OI

I am not quite sure if this what you are really looking for but here are some links for you to take a look at:

Link 1[^]
Link 2[^]
Link 3[^]

As far as I know in SQL Server 2000 you can import your excel sheet into a table in your database (via DTS) and then update your table from the excel table you might able to do that with 2008 as well. Look for into that as well.

Good luck,
OI

这篇关于是否可以通过将数据与Excel文件进​​行比较来更新数据库中的现有值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！