SharePoint Document Issues

Fix an Access Append Query That Stops Importing Records to SharePoint

Steven ParkerSteven Parker Nov 18, 2026 868 views

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.

Fix an Access Append Query That Stops Importing Records to SharePoint
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.
Before you start

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.

Solution 1Recommended

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.

1
Check list access

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.

2
Limit the source records

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.

3
Run and verify the batch

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.

4
Continue with remaining records

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.

Test the Access append query with smaller batches
The cause may vary: Server load, connectivity loss, or the size of the bulk operation may contribute to the failure. A successful small batch does not by itself identify the cause.
Free Microsoft Office alternative

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.

Review and organize source spreadsheet records before an importOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
QA img-9

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.