如何用另一个表中的值替换表中的值？
这是我的情况，我的组织已经更改了客户的ID，但是来自系统的原始数据仍然保留旧值。
我的问题是如何更改/编辑/替换值顾客的身份证表
我的餐桌是这样的：
姓名| ID |细节
qwe | 20015 | ynu
abc | 20016 | nhf
xyz | 20017 | y5h
和表格内容新ID如下：
ID新| ID old
abc | 10001 | 20015
xyz | 10002 | 20016
qwe | 10003 | 20017
如何更换客户ID表中的ID？
宏？ vba？我不能使用查找和替换，因为我有太多的ID要更改。
请帮帮我，谢谢。
this is my situation, my organization have changed the customer''s ID, but data raw from system still keep old value.
my question is how to change/edit/replace the value in the customer''s ID table
my tables are like this:
Name | ID | detail
qwe | 20015 | ynu
abc | 20016 | nhf
xyz | 20017 | y5h
and the table content new ID is like this:
Name | ID new | ID old
abc | 10001 | 20015
xyz | 10002 | 20016
qwe | 10003 | 20017
what can I do to replace ID in customer''s ID table ?
macro ? vba ? I can''t use find and replace since I have too much ID to change.
please help me, thank you.
您可以针对旧表编写和更新查询，并将ID替换为新ID。
You could write and Update Query against the Old table and replace the ID''s with the New IDs.
更新似乎无法正常工作，它不会更新任何客户的ID表..
the update seem not work correctly, it update nothing to the custumer''s ID table..
您需要发布您的代码，以便我们可以告诉您它的错误。
You need to post your code so we can tell you what''s wrong with it.