Data Import & Export

How to Append Excel Data to Access When Field Names Differ

Emma BrownEmma Brown Nov 13, 2026 869 views

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 you start

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.

Solution 1Recommended

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.

1
Open Access and create a query in Design View

In Microsoft Access, go to Create > Query Design and close the Show Table dialog after adding only the linked Excel source table.

2
Switch the query to an Append query

On the Query Design tab, click Append, select the destination Access table as the Append To table, and click OK.

3
Add source fields individually

Double-click each Excel source field that you need to append. Avoid double-clicking the asterisk or adding the destination table.

4
Map each source field to the destination field

In the Append To row under each column, choose the matching destination Access field from the drop-down list, even if the names differ.

5
Run and verify the append query

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.

Mapping complete: The append query runs even when header names differ as long as every required source column is mapped to the correct destination field.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office website and download the free installer for your Windows or macOS device.
  2. 2. Install and launch WPS Office: Run the installer, open WPS Office, and choose to associate Excel-compatible spreadsheet files with WPS Spreadsheets.
  3. 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. 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.
Handles .xlsx Excel files with strong format compatibility for data cleanup and reporting.Free, lightweight Office alternative that runs smoothly on everyday devices.Familiar ribbon-style interface reduces the learning curve when switching from Microsoft Office.Lets you open, filter, and prepare Excel form export data before reuse.
microsoft office alternative - wps office

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.