Data Import & Export

How to Import Microsoft Access Records Without Duplicates Using SQL

Emma BrownEmma Brown Nov 13, 2026 869 views

Question details

The user needs to append records from one Microsoft Access table to another table with the same structure without creating duplicate rows.

How to Import Microsoft Access Records Without Duplicates Using SQL
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Query Wizard

In Microsoft Access, open the database and click the Create tab on the ribbon, then click Query Wizard.

2
Start the Find Unmatched Query Wizard

Select Find Unmatched Query Wizard and click OK.

3
Choose the tables to compare

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.

4
Define the matching fields

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.

5
Preview and append unmatched records

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.

Create an Unmatched Query with the Query Wizard and Append Only Unmatched Records
Duplicates prevented: Only source records that do not already exist in the destination table are appended.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free.
  2. 2. Install and open WPS Office: Run the installer, sign in or skip, and open WPS Office from the desktop shortcut.
  3. 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.
Free to download and use for everyday spreadsheets, documents, and presentations.Strong Microsoft Office format compatibility for .xlsx, .docx, and .pptx files.Familiar ribbon-style interface reduces the learning curve when switching from Microsoft Office.Lets you clean, filter, and import tabular data in WPS Spreadsheets without needing Access.
microsoft office alternative - wps office

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.