访问/MS 365企业：在访问表中的字符串中查找特定文本，并更新每个实例
我有一个带有80k+记录的文件，我将其与访问查找地址更改的另一个文件进行比较。问题在于地址列中的数据不是苹果的苹果，因此使用查询我更改所有实例以匹配。然后，我比较捕获真正的地址只会更改，而不是生成仅基于“ apt”与“公寓”不匹配的5,000个记录的列表。暂时，我创建了太多的查询来执行此操作，但是我知道可以通过一个或两个模块或一个SQL查询更简单地完成此操作，我可以在一个查询中列出我想做的所有更新，而不是一个用于每个文本字符串。如果有人可以将我指出一个回答的问题（因为似乎没有任何专门关联）或查明我需要的确切功能，我可以进行进一步的研究并学习如何合并它。
表名称：Vendordemo
字段名称：HOME地址1
在“ 123 Main Dr”中的“ 123 Main Dr”中的“ dr”中找到“野外家庭地址
1 ，但想知道要特别注意的是什么，并开始跳跃。
I have a file with 80K+ records that I compare to another file in Access to find address changes. The problem is that the data in the address columns are not apples to apples, so using queries I change all instances to match. I then compare to capture true address changes only and not generate a list of 5,000 records that only mismatch based on "apt" versus "apartment", for example. Temporarily, I created way too many queries to do this, but I know it can be done much more simply with a module or two, or a sql query where I can list all the updates I want to do in one query rather than one for each text string. If someone can point me to an answered question (since nothing seems to relate specifically) or pinpoint the exact function I need, I can do further research and learn how to incorporate it.
Table Name: VendorDemo
Field Name: Home Address 1
FIND "Dr" within the address string of "123 Main Dr" in field Home Address 1 and REPLACE with "123 Main Drive" for all records in the table
Starting Udemy course on it right now, but would like to know what to pay particular attention to and to get a jump start on it.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以使用 ms access 中的查找和替换选项，CTR+F。仔细查看我在查找和替换对话框中选择的选项。
我附上了查找和替换完成之前和之后的表数据的图像。
You can use the find and replace option in ms access, CTR+F. look closely at the options I picked in the find and replace dialog box.
I have attached the image of the table data before and after the find and replace is done.