Sharepoint - 如何从 Excel 文件更新列表 [英] Sharepoint - How to update list from a Excel file

问题描述

我在 Sharepoint 中有一个列表，我每周都会用 Excel 文件更新它...

I have a list in Sharepoint, and I update it every week with a Excel file...

但是每次我这样做时，我都必须删除所有项目并导入我的 Excel 文件..

But every time I do it, I have to delete all items and import my Excel file..

有没有更简单的方法来做到这一点?

Is there an easier way to do this?

我想在 Access 中，但我不知道是否可行

I was thinking in Access, but I dont know if it is possible

推荐答案

您可以使用 Excel 或 Access:

You can do it with Excel or Access:

Excel:http://office.microsoft.com/en-in/sharepoint-help/synchronize-a-list-with-a-spreadsheet-program-HA102815832.aspx

访问:http://office.microsoft.com/en-ca/access-help/import-from-or-link-data-to-a-sharepoint-list-HA102749600.aspx

这篇关于Sharepoint - 如何从 Excel 文件更新列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！