sharepointsharepoint-2010

Sharepoint - How to update list from an 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

Solution

  • 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