Data Import & Export

Fix Excel Importing Fewer Records from an Access Query

Steven ParkerSteven Parker Nov 18, 2026 869 views

Question details

Identify why an Excel connection imports fewer records than an Access query returns.

Fix Excel Importing Fewer Records from an Access Query
Product
Microsoft Excel and Microsoft Access
Device & OS
not provided
Scenario
A user imports the results of an Access query into Excel through a connection.
Observed behavior
The Access query returns 60,604 records, while Excel imports 60,446.
Before you start

Refresh the Access query and note its record count, then refresh the Excel connection and count the imported table rows. Confirm that both use the same database, query, parameters, and date filters.

Solution 1Recommended

Compare the Access query with the Excel connection

Use this check to find differences in the data source, query logic, or connection settings.

1
Inspect the Access SQL

In Access, open the query in Design View and select View > SQL View. Review the source tables, joins, WHERE conditions, and any DISTINCT or grouping clauses.

2
Check the Excel connection

In Excel, open Data > Queries & Connections. Select the relevant query or connection and inspect its source and properties; compare its SQL, filters, and parameters with the Access query where available.

3
Refresh and count the results

Select Data > Refresh All in Excel, then check the number of rows in the imported table. Compare that count with the refreshed Access query rather than using a count of a column that may contain blank values.

4
Check the destination

Inspect the imported table or connection properties in Excel to confirm that the full result is loaded and that a restricted output range or worksheet filter is not hiding records.

Compare the Access query with the Excel connection
The cause needs investigation: The record counts alone do not identify which setting or query condition caused the difference.
Free Microsoft Office alternative

Review Excel Workbooks with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheet files. Its familiar interface and Excel format support make it easy to move existing workbooks, though it does not fix an Excel-to-Access connection.

Open and review imported spreadsheet data in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Could a join cause records to disappear during import?

Yes. An inner join excludes rows without a match in the other table. Compare the joins in Access SQL View with the merge steps in Power Query Editor, including how null keys are handled.

How can I find which records are missing in Excel?

Load comparable Access and Excel results into Power Query, then use Merge Queries with a left anti join on a stable record ID. Check duplicates separately if the ID is not unique.

Can filters make the Excel count appear lower?

Yes. Check both the worksheet table's filter buttons and the Applied Steps in Power Query Editor. Also compare date conditions and parameters with the Access query.

Is 60,604 rows too many for an Excel worksheet?

No. A modern Excel worksheet supports 1,048,576 rows. Check the connection and destination settings if fewer records are loaded, and allow for a header row when assessing capacity.