Sharepoint - How to update list from a Excel file

问题:

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

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?

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

回答1:

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

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

回答2:

You can use Datasheet view. Create a view containing all required fields. Open that view using Datasheet view action in ribbon. You can use Copy and Paste operations to import data from Excel to sharepoint list.

回答3:

Export key is enabled when your data is in tabular format