提示类型转换失败，求救。。。。

你的这个更新查询有问题：请核实。

UPDATE [PPC_Retailer_Check by Standard] SET Brand = 'INSTR(SELECT Brand.BRAND FROM Brand , [PPC_Retailer_Check by Standard] WHERE [PPC_Retailer_Check by Standard].DESCRIPTION  like '*'Brand.DESCRIPTION'*')'
WHERE [PPC_Retailer_Check by Standard].Brand IS NULL;

select 语句应纠正如下：

SELECT Brand.BRAND FROM Brand, [PPC_Retailer_Check by Standard] WHERE ((([PPC_Retailer_Check by Standard].DESCRIPTION) Like '*' & [Brand].[DESCRIPTION] & '*'))

感觉你的要求并非简单的更新查询可以搞定。需要用一个循环依据每个条件来运行更新查询然后更新相应的字段值。