How to Append Excel Data to Access When Field Names Differ
Question details
The user needs to append records from an Excel form export into an existing Microsoft Access table when the source column headers and destination field names follow different naming conventions, such as spaces and special characters versus underscores.
- Product
- Microsoft Access and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A form export from Excel must be added to a destination Access table, but the export uses original form headers while the Access table uses renamed fields with underscores.
- Observed behavior
- The append operation fails when the source and destination names do not match, and using the asterisk or adding both tables does not complete the mapping.
Before creating the append query, open the linked Excel source table in Access and confirm the exact source header names, then open the destination Access table in Design View to note the destination field names you need to match.
Create an Access Append Query and Manually Map Excel Columns to Access Fields
Use this method when the Excel source headers and Access destination field names don't match, because Access cannot automatically map renamed fields.
Do not add both tables to the query grid or use the asterisk. The reliable approach is to add only the source table, choose Append, select the destination table, and map each source field individually in the Append To row.
In Microsoft Access, go to Create > Query Design and close the Show Table dialog after adding only the linked Excel source table.
On the Query Design tab, click Append, select the destination Access table as the Append To table, and click OK.
Double-click each Excel source field that you need to append. Avoid double-clicking the asterisk or adding the destination table.
In the Append To row under each column, choose the matching destination Access field from the drop-down list, even if the names differ.
Click Run, check the number of rows to append, and open the destination Access table to confirm the records were added to the correct fields.
Use WPS Office as a Free Alternative for Excel-Compatible Data Work
WPS Office does not include Microsoft Access, so Access append queries must be fixed inside Microsoft Access. For day-to-day spreadsheet, document, and report tasks, WPS Office offers a free, lightweight solution with familiar menus and strong Excel format compatibility for a smooth transition.
- 1. Download WPS Office: Go to the official WPS Office website and download the free installer for your Windows or macOS device.
- 2. Install and launch WPS Office: Run the installer, open WPS Office, and choose to associate Excel-compatible spreadsheet files with WPS Spreadsheets.
- 3. Open your Excel data in WPS Spreadsheets: Click Spreadsheets, open the exported Excel form file, and use the familiar ribbon tools to filter, clean, or review the data.
- 4. Save in Excel-compatible format: Use Save As to keep the file in .xlsx format so it remains ready for import into other systems or for further use.

Frequently Asked Questions
Why does my Access append query fail when the Excel headers contain spaces and special characters?
Access does not automatically match source columns to destination fields when the names differ. You must map each source column individually in the Append To row of the append query.
Should I add the destination Access table to the append query?
No. Add only the source Excel table to the query. Then choose the destination table in the Append dialog and set the destination field under each source column individually.
Can I use the asterisk to add all fields during an append with different field names?
Avoid using the asterisk for this scenario. Double-click each source field separately so you can map every column to the matching renamed destination field.
Does WPS Office include Microsoft Access or an Access equivalent?
WPS Office does not include a database application that replaces Microsoft Access. For Access append queries, complete the mapping in Microsoft Access; WPS Office can be used to open and prepare Excel-compatible data files.




