Hi,
I understand that you are using Access and Excel 2010 to sync data to a SharePoint list. Since the error comes after there are 9500 of records, you can decrease the items to see whether it fixes this issue.
Another way to sync data to SharePoint using Excel alone is also available. You need to install the sync add-in for Excel 2010. Then click File>Options>Add-Ins. Browse and check the add-in for excel. Then you can get the Publish and Allow Sync button
will appear under Design ribbon in Excel.
Here is a link for Excel 2007 sync Add-in, this add-in still works in Excel 2010:
Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists:
http://msdn.microsoft.com/en-us/library/office/bb462636(v=office.11).aspx
Thanks,
Entan Ming
TechNet Subscriber Support in forum
If you have any feedback on our support, please contacttnmff@microsoft.com.
Entan Ming
TechNet Community Support
