Fix Microsoft Access “Property Value Is Too Large” When Appending Excel Data
Question details
The user needs a reliable way to append Excel records to an Access table without the “Property value is too large” error or suppressing import warnings.

- Product
- Microsoft Access, importing Microsoft Excel workbook data
- Device & OS
- not provided
- Scenario
- An append query imports Excel data into an existing table as part of a recurring data-loading workflow.
- Observed behavior
- The append query fails with “Property value is too large.” Changing field formats and import methods has not produced a reliable fix, although ignoring warnings and reopening the database reportedly allows the query to work.
Open the destination table in Design View and the append query in Design View, and keep the source workbook available for comparison. Record the exact error message and retain any import-error table Access creates so you can identify rejected fields or records.
Match Excel values to the Access destination fields
Start here to identify incompatible values, incorrect field mappings, or destination rules that prevent records from being appended.
Excel cell formatting does not guarantee that every value in a column has the same underlying type. Access imports and append queries must also satisfy the destination table’s field types, sizes, indexes, and validation rules.
In the Access Navigation Pane, right-click the destination table and select Design View. Check each field’s Data Type and, in Field Properties, review Field Size, Required, Allow Zero Length where available, Validation Rule, and Indexed.
Right-click the append query and select Design View. Compare each source field with its Append To destination. If the destination uses an AutoNumber primary key and the incoming IDs do not need to be preserved, remove the source ID from the append mapping and let Access generate the values.
Open the source workbook and use Data > Filter to inspect text, date, and numeric columns for inconsistent values. Check text lengths against the Access field size, distinguish actual dates from text that looks like a date, and remove nonnumeric placeholders from numeric fields. If longer text is legitimate, consider a Long Text destination field rather than truncating the data.
In Access, open the append query in Datasheet View to inspect the selected records, then return to Design View and select Run. Keep confirmation and error messages enabled; if records are rejected, use those details to correct the relevant values or constraints before retrying.
Compact and repair the Access database
Use this if field mappings and source values appear correct but the error persists, particularly if closing and reopening the database changes the result.
Validate Excel records in a staging table before appending
Use a staging workflow when direct imports remain unreliable or you need a repeatable process for daily loads.
Prepare Excel Import Data with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and Excel format compatibility for easy migration. Use WPS Spreadsheets to inspect and clean the source workbook before importing it into Access. It does not repair Access databases or run Access append queries.

Frequently Asked Questions
Does “Property value is too large” mean my Access table has too many rows?
Not necessarily. This message alone does not establish a row-count or memory problem. Start by opening the destination table in Design View and checking field definitions, then inspect the append query’s mappings and source values. Testing a small, defined batch can help distinguish a record-specific problem from a broader database issue.
Should I append the Excel ID column to an AutoNumber field?
Usually not if Access should create new IDs. In the append query’s Design View, remove the source ID field from the append mapping. Preserve incoming IDs only when your workflow requires them and you have checked that they do not conflict with existing keys or related records.
Can changing an Excel column’s format fix the import?
Changing the display format alone may not convert the stored values. Open the workbook, use Data > Filter to inspect inconsistent entries, and convert or correct the actual values. Then compare them with the destination field’s Data Type and Field Size in Access Design View.
Is it safe to ignore warnings if the append query eventually works?
No. Suppressing warnings can hide rejected records or partial appends. Keep warnings enabled, review any import-error table, and compare the expected incoming records with the destination. Before retrying, check whether an earlier attempt already inserted some records.
Can WPS Office fix this Access error directly?
No. WPS Spreadsheets can open the Excel source file and help you filter, inspect, and correct its values, but it does not repair Access database files or execute Access append queries. Perform those steps in Microsoft Access.




