ACCESS 2010/SQL:如何复制具有附件字段的行? [英] ACCESS 2010 / SQL: How do you copy a row which has an attachment field?

问题描述

我想运行一个SQL查询以将行从我的表复制到同一表或另一表.

I want to run a SQL query to copy a row from my table to either the same table or another table.

无论使用哪种方法，我最终都会收到一条消息，告诉我类似于如果它包含多值字段，您将无法运行INSERT INTO查询"(从法语翻译) 我尝试使用SELECT * INTO，但结果是相同的.

Whichever method I use, I end up with a message telling me something similar to "You can't run an INSERT INTO query if it contains a multi-value field" (translated from french) I tried using SELECT * INTO, but the result is the same.

我的表是关于报告的，报告可以有修订(因此有行副本)，并且可以有ex的附件. pdf文件.

My table is about reports, which can have a revision (hence the row copy), and they can have an attachment like for ex. a pdf file.

那么，您/如何复制具有附件字段的行?

so, how do you / can you copy a row which has an attachment field ?

谢谢

推荐答案

目前我没有Access 2010，但是您会发现附件以单个记录的形式存储在隐藏的系统表中，您需要使用该表可以复制多个记录，除非您希望使用VBA.

I do not have Access 2010 to hand at the moment, but you will find that attachments are stored in hidden system tables as single records and that you need to use that table to copy multiple records, unless you wish to use VBA.

更多信息: http://office.microsoft.com/zh-cn/access-help/guide-to-multivalued-fields-HA001233722.aspx?pid=CH100645681033
http://msdn.microsoft.com/en-us/library/bb258184.aspx

More info: http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx?pid=CH100645681033
http://msdn.microsoft.com/en-us/library/bb258184.aspx

这篇关于ACCESS 2010/SQL:如何复制具有附件字段的行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！