与访问同步 [英] Synchronize with Access

问题描述

根据下面的帖子，您

无法同步 SP讨论板和访问权限

Cannot synchronize a SP Discussion Board and Access

我有O365，并尝试链接到SP讨论委员会，这似乎证实了这一点.

I have O365 and have tried to link to a SP Discussion Board, which, seemingly confirms this.

有人经历过吗?我相信我可以设置列表" (或桌子)本人，但宁愿不这样做.我想知道他们为他们建立的关系，并假设我可以尝试将它们导出为Excel，以查看它是否很清晰-但是 如果有更好的方法，这一切似乎都需要很大的努力.

Has anyone experienced this? I believe I could setup the "lists" (or tables) myself, but would rather not. I'd like to know the relationships they've setup for them and suppose I could try to export them as Excel to see if it sheds light - but all this seems like a lot of effort if there's a better way.

请帮助

谢谢

推荐答案

LexKinter，

Hi LexKinter ,

我使用Access 2013测试了SharePoint 2013，并且可以将讨论区列表导出到Access 2013:

I test SharePoint 2013 with Access 2013 and I can export the discussion board list to Access 2013 :

不是Test Access 2010，但是如果它不能像上面提到的KB那样进行同步，则可以:

Not Test Access 2010 , but if it cannot sync like above KB mentioned , you can :

• 将讨论板连接到Outlook.
• 在Outlook收件箱中创建一个新文件夹.
• 在Outlook中找到SharePoint列表，然后将其中的所有项目复制到新的文件夹中.您创建的文件夹.
• 将新文件夹导出到制表符分隔值(Windows)"文件中. <-重要
• 使用记事本打开导出的文件.
• 将所有内容复制并粘贴到Excel中.

• Connect the Discussion Board to Outlook.
• Create a new folder in your Outlook inbox.
• Find the SharePoint list in Outlook and copy all of the items from there to the new folder you created.
• Export the new folder to a Tab Separated Values (Windows) file. <-- Important
• Open the exported file with notepad.
• Copy all and Paste into Excel.

最好的问候，

安东尼

这篇关于与访问同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！