I have been using this process for quite a while and while it is a bit cumbersome it has always worked
SharePoint 2016 Access 2013 Excel 2013
- Open Access
- Create ne DB
- External Data Connect to SharePoint List
The Import Excel Spreadsheet into linked list
I have always been able to import anywhere up to 5,000+ records... Starting today it dies consistently after 1,000 records every time I try with the following error...
Cannot Update. Database or Object is read-only