How to Import Microsoft Access Records Without Duplicates Using SQL
Question details
The user needs to append records from one Microsoft Access table to another table with the same structure without creating duplicate rows.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user is working with two identically structured Access tables and wants to import only new or unmatched records from the source table into the destination table.
- Observed behavior
- Appending every record from the source table can create duplicates when matching rows already exist in the destination table; the goal is to compare relevant fields and append only non-matching records.
Identify the field or combination of fields that uniquely defines a matching record between the source and destination tables, and confirm both tables use the same structure and data types for those comparison fields.
Create an Unmatched Query with the Query Wizard and Append Only Unmatched Records
Use this visual method when you want Access to compare two tables and show only source rows with no matching destination row before you append them.
The Find Unmatched Query Wizard is the safest built-in way to isolate new records because it does not delete or change existing destination rows.
In Microsoft Access, open the database and click the Create tab on the ribbon, then click Query Wizard.
Select Find Unmatched Query Wizard and click OK.
Select the source table, for example TableA, as the table containing the records you want to append, then select the destination table, TableB, that already has existing records.
Select the field or fields that must match between the two tables, such as an ID, order number, or combination of fields, and click Next.
Choose the fields to display, run the query to preview non-matching rows, then switch to Query Design, click Append, choose the destination table, map the fields, and click Run.

Use a LEFT JOIN in SQL View to Append Non-Matching Records
Use this direct SQL method when you are comfortable editing SQL and want a single query to compare and append records.
Use a NOT EXISTS Subquery to Exclude Existing Records
Use this alternative if you prefer a subquery filter that checks the destination table for each source row.
Use WPS Office as a Lightweight Microsoft Office Alternative for Everyday Data Work
WPS Office does not include Microsoft Access or run Access SQL, but it is a free, lightweight Office suite that opens and edits common Microsoft Office files, making it a practical companion for spreadsheet-based data import and export tasks.
- 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
- 2. Install and open WPS Office: Run the installer, sign in or skip, and open WPS Office from the desktop shortcut.
- 3. Open or create a spreadsheet: In WPS Office, click Spreadsheets, then open an existing .xlsx or .csv file or create a new workbook to manage your data imports.

Frequently Asked Questions
Does WPS Office support Microsoft Access SQL queries?
No. WPS Office does not include Microsoft Access or an Access SQL engine. Run Access SQL in Microsoft Access, or use WPS Spreadsheets for Excel-compatible data import, filtering, and cleanup.
How can I preview which records will be appended before changing the destination table?
Use Create > Query Wizard > Find Unmatched Query Wizard in Microsoft Access. The wizard compares the two tables and displays only source rows that have no match in the destination table.
Can I use more than one field to identify duplicates?
Yes. In the unmatched query, join multiple fields with AND conditions, or use a calculated field that combines values such as CustomerID and OrderDate into a single comparison key.
Should I delete existing records before appending to avoid duplicates?
Only delete first if you intend a complete replacement and have verified the deletion criteria. For routine imports, append only unmatched records so existing data stays intact.
What SQL alternatives work besides a LEFT JOIN?
A NOT EXISTS subquery or an unmatched Query Wizard both produce the same result. Choose the method that is easiest to maintain for your database.




