For a SharePoint 2010 solution I need to sync serveral excel files with some lists(1:1). This solution is running at a big company where we do not have any possibilities for serversite coding. At this moment we sync with a MS Access query. This is not a good solution because is not stable and can not run without user interaction.
the final solution:
- daily new excel files (one with 10 000 records other ones smaller) or automatically set in a directory (or sharepoint doc library). this ia already happening.
- 'something' needs to run and sync the excel with the sharepoint lists.
- we prefer sync and not just delete and insert again.