Fix an Access Append Query That Stops Importing Records to SharePoint
Question details
The user needs to import approximately 6,000 Excel records into a linked SharePoint list using an Access append query without the operation stopping.

- Product
- Microsoft Access and SharePoint
- Device & OS
- not provided
- Scenario
- An Access append query inserts records from Excel into a linked SharePoint list.
- Observed behavior
- The query sometimes stops after inserting part of the data and reports that the database or object is read-only.
Check how many items were already added to the SharePoint list and identify a unique record field so you can avoid inserting duplicates when retrying. Note the exact error message and your Access version under File > Account > About Access.
Test the Access append query with smaller batches
Use smaller batches to determine whether the failure is related to the size of the operation, connectivity, or SharePoint responsiveness.
Open the target list in SharePoint and confirm that your account can add an item. Check that the Access database and linked list are open and available.
Open the append query in Access Design View and add criteria to a suitable source field, such as an ID range, to select a smaller set of Excel records.
Select Run on the query design ribbon, allow SharePoint time to respond, and check the target list for the inserted items and any error message.
Adjust the query criteria to select records not yet inserted, then run the next batch. Compare unique record values in the source and SharePoint list before retrying a failed batch.

Isolate the issue with a new database and SharePoint list
Compare results in a separate database and list to narrow down where the error occurs.
Use another method to import the Excel records into SharePoint
Consider a different import method if the Access append query continues to stop.
Prepare Excel Data with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for reviewing spreadsheet data and moving between Office-compatible files. It does not fix Access append queries or replace SharePoint list imports.

Frequently Asked Questions
Why does Access report that the SharePoint list is read-only partway through an append query?
The cause is not established by the message alone. Server load, a lost connection, or the size of the operation may contribute. Check that you can add an item in SharePoint, then test a smaller batch in Access.
How can I retry without duplicating records already added?
Check the target SharePoint list against a unique field in the Excel source. In Access Query Design View, add criteria that select only records not yet inserted before running the append query again.
Can I import the Excel file directly into SharePoint?
You can try SharePoint's New > List > From Excel option to create a new list from a workbook. Review the proposed columns and applicable import limits; this does not append the data to an existing list.
What information should I collect if the error continues?
Record the version shown under Access File > Account > About Access, capture the exact error message, and note how many records were inserted. Test with a new database, a smaller Excel file, and another SharePoint list.




