使用 SP 列表中的查找字段将来自 Access 的查询附加到链接的 SharePoint 列表
我正在尝试将 MS Access 表（我使用的是 Access 2010，但如果需要的话可以使用 2007）中的记录附加到链接的 SharePoint 列表中。
有一个附件字段（从 Access 查看时），但我不关心附加这些附件。
SharePoint 列表有一些查找字段，在设计视图中为数字格式。升级到 SQL Server，我可以确认它们是数字（并且我假设相关 SharePoint 列表对象的 ID）。
我复制了 SharePoint 列表的结构并粘贴到 MS Access 表中，然后填写了一些示例记录
我使用查询向导选择了 Access 表的所有字段（减去 Access 表的自动编号 ID 和附件），单击“追加”，然后选择 SharePoint 列表。
如果我运行此查询，我会收到由于验证违规原因而未附加 X 条记录的错误，这是所有这些原因。我已经检查了所有字段定义，但没有一个字段定义为必需的或具有验证约束。
我唯一能想到的是查找字段存在一些问题，但我检查的每个数字 Id 都是有效的 Id。
我希望有一个 MS Access 解决方案，但如果唯一的方法是以编程方式执行此操作，有人可以向我发送有关如何开始使用 SharePoint 3.0 SDK 的说明吗？
感谢您抽出时间。
I am trying to append records in an MS Access table (I am using Access 2010, but can use 2007 if need be) into a linked SharePoint list.
There is an attachments field (when viewed from Access), but I am not concerned with appending these.
The SharePoint list has a few lookup fields, that in design view are of the Number format. Upsizing to SQL Server, I can confirm that they are numbers (and I assume the Id for the related SharePoint list object).
I copied the structure of the SharePoint list and pasted into a MS Access table, and then filled in a few sample records
I used the query wizard to select all of the fields of the Access table (minus the Access table's autonumbered ID and attachments), click "Append", and then selected the SharePoint list.
If I run this query, I get the error that X record(s) were not appended due to validation violation reasons, which is all of them. I've checked all field definitions and none are defined as required or have a validation constraint.
The only thing I can think of is that there is some issue with the Lookup fields, but each number Id I've checked is a valid Id.
I'm hoping for a MS Access solution, but if the only approach is to programmatically do it, could someone send me directions on how to get started with the SharePoint 3.0 SDK?
Thank you for your time.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
查找列不是数字类型，即使您的父项是数字类型，查找列背后的原因始终附加父项的项 ID。如果您想查看 Access 中的数据，请使用数据表视图中提供的“导出到 Access”功能
Lookup columns are not number type even your parent items are of number type reason behind lookup column always attaches the item id of parent item.If you want to see the data in access kindly use the "export to Access" functionality available in datasheet view
我已链接到一个 SharePoint 表，然后通过查询直接附加到该表。
我的问题是，此过程需要很长时间才能推送到 SharePoint，而当我第一次需要在附加之前删除列表中当前的记录时，需要花费 2 倍的时间。
由于它不是 Access 对象，是否有更好的方法来吹出并创建表，同时保留链接？
无论如何，我希望这可以帮助您并让我获得一些见解。
问候。
I have linked to a SharePoint table, then appended directly to it from a query.
My issue is that this process takes a very long time to push up to SharePoint, then 2 times as long when first I need to delete the records currently in the list before appending.
Is there a better way to blow out and create the table while preserving the link since it is not an Access object?
Anyway I hope this may help you out some and get me some insight as well.
Regards.