Rename or Map Table Fields with Microsoft Access Queries
Question details
The user needs to use different field names for imported report data or map fields between Access tables.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- An imported report has field headings that differ from the client's required headings, or its data needs to be copied into a destination table.
- Observed behavior
- The source and required destination field names differ, so the query must provide the correct headings or field mapping.
Identify the source fields and the required output or destination field names. If copying or updating records, check the destination field types and the key used to identify matching records.
Use a SELECT query to display fields with different headings
Use aliases when you only need the client's headings for a report or export, without copying or changing table data.
In Access, select Create > Query Design, then switch to SQL View.
Enter a query such as SELECT [FieldA] AS [FieldX], [FieldB] AS [FieldY] FROM [MyTable]; replacing the table and field names with your own.
Select Run to check the headings and results, then save the query. Use the saved query as a report source or export its results.

Use an Append query to add records to another table
Use this method when new source records must be added to a destination table whose fields have different names.
Use an Update query to change existing destination records
Use an Update query when matching records already exist and their field values need to be changed.
Work with exported Access report data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for working with exported spreadsheet data. It does not run Access queries, but you can export query results from Access and open them in WPS Spreadsheets for further editing.

Frequently Asked Questions
Does a SELECT alias rename the field in the original table?
No. An expression such as [FieldA] AS [FieldX] changes the heading in the query results, not the field name in the source table.
When should I use an Append query instead of an Update query?
Use Append to add new records to a destination table. Use Update to change field values in records that already exist.
Can I reuse the query after importing another report?
Yes. Save the SELECT query and run it again after importing the new report, provided the query can still find the expected source table and fields.
Will appending records delete them from the source table?
No. An Append query copies selected records into the destination table; it does not remove the source records.
Can WPS Office run my Access query?
WPS Office does not run Access queries. Run the query in Access, export its results to an Excel file, and then open that file in WPS Spreadsheets.




