阅读背景:

使用Union Function创建更新查询?

来源:互联网 

I have an Excel table that I import to an Access 2010 database table. The only problem is the data for one field (Health Plan) is not consistent with what we currently use in our database. For example the data that is being imported shows "GA" vs what it should be, "CHC - GEORGIA". I'm able to make a simple Update query for changing ONE at a time, but I have 15+ states that need to be changed. This is what I was shooting for in combining these into one query:I have an Excel table that I import to an Acces




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: