Fix Excel Importing Fewer Records from an Access Query
Question details
Identify why an Excel connection imports fewer records than an Access query returns.

- 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.
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.
Compare the Access query with the Excel connection
Use this check to find differences in the data source, query logic, or connection settings.
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.
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.
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.
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.

Test the import one Power Query step at a time
Use Power Query to locate the first transformation that changes the expected row count.
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.

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.




