Sharepoint - How to update list from an Excel file

Question

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

Answer 1

Export key is enabled when your data is in tabular format

Answer 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.

Answer 3

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