Others

Fix Access Query Excluding Records After Importing Excel Data

Huma Ashraf Ch Oct 7, 2026 869 views

Question details

Users are missing records in an Access database query after importing contact data from an Excel spreadsheet.

How to Fix Access Query Excluding Records After Importing Excel Data

Product: Microsoft Access
Device & OS: not provided
Scenario: Running a database query after importing contact data from an Excel spreadsheet into a Microsoft Access table.
Observed behavior: The query only returns a partial list of records because the missing records do not have matching entries in a related table, despite the imported data being visible in the main table.

Before you start

Open your Microsoft Access database and verify that all imported records from Excel are fully visible in the main contact table before modifying query settings.

Solution 1Recommended

Change the Query Join Type to a Left Join

Modify the relationship in your query from an Inner Join to a Left Join so that all records from the imported table are displayed regardless of matching entries in the related table.

By default, Access queries often use an inner join, which only returns records that have matching data in both connected tables. If your newly imported Excel records lack corresponding data in the related table, they will be excluded. A left join solves this by prioritizing all records from the main table.

Open Query Design View

Right-click on your problematic query in the Navigation Pane and select 'Design View'.

Access Join Properties

Locate the line connecting your main contact table (with the imported Excel data) to the related table. Double-click the join line to open the Join Properties dialog box.

Select the Left Join Option

Select the option that states 'Include ALL records from [Your Main Table] and only those records from [Your Related Table] where the joined fields are equal'. Click OK to apply.

Run the Query

Click the 'Run' button (the red exclamation mark) in the Query Design ribbon to verify that all records are now displayed, with blank fields where related data is missing.

Change the Query Join Type to a Left Join

Apply to All Relevant Queries: You must manually edit the join properties in every query that needs to display records without matching related entries.

Free Microsoft Office alternative

Manage and Clean Spreadsheet Data Seamlessly with WPS Office

While Microsoft Access is used for relational databases, properly cleaning and preparing your data in spreadsheets before importing is crucial. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office, making it easy to manage your data files.

1. Download WPS Office: Install WPS Office for free from the official website.
2. Open Data Files: Open your contact data spreadsheets seamlessly in WPS Spreadsheet.
3. Prepare Data for Import: Use built-in functions like VLOOKUP to cross-reference data and prevent unmatched records before importing into a database.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) for seamless data preparation.Lightweight design ensures fast loading and smooth processing of large datasets.Familiar user interface allows you to start working immediately with no learning curve.Free built-in data validation tools to identify missing related data before database imports.

microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between an inner join and a left join in a database query?

An inner join only displays records when there is a match in both joined tables. A left join displays all records from the primary (left) table and only matching records from the secondary (right) table, leaving unmatched fields blank.

Why does my imported Excel data show up in the table but not the query results?

This happens when your query uses an inner join linking the newly imported table to another table. If the new Excel data lacks corresponding entries in the second table, those unmatched records are entirely excluded from the query view.

How can I easily find all unmatched records after importing data?

You can use the 'Find Unmatched Query Wizard' built into your database software. It automatically generates a query that compares two tables and isolates the records in your imported table that lack related matching entries.

Office Quick Solutions