使用多个值附加查询 [英] Append Query with multi values
问题描述
我正在尝试将信息附加到新数据库中。旧项目信息具有多个值的多个字段。显然,追加查询无法处理此问题。有没有办法解决这个问题?
I am attempting to append information into a new database. The old project information has some fields that are multi-value. Apparently an append query cannot handle this. Is there a way I can over come this?
推荐答案
你好b $ b>>显然一个追加查询无法处理这个问题
Hi>>Apparently an append query cannot handle this
你有错误吗?你遇到的问题是什么?你能否展示你正在使用的sql或分享一个样本来重现这个?
Have you got some error? What's the problem you have encountered? Could you please show the sql you are using or share a sample to reproduce this ?
如果你要为你的多值字段添加一个值,你可以给我们一个这样的追加查询,
If you're adding a value to your multi-valued field, you can us an append query like this,
插入表格(FieldName.value)值(值)
Insert into table (FieldName.value) values (value)
最好的问候
Lan
这篇关于使用多个值附加查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!