Data Import & Export

Fix an Empty Access Query Import in Excel

Phi Hung VoPhi Hung Vo Nov 20, 2026 869 views

Question details

A user needs to import the results of a saved Access query into Excel when the query contains criteria.

Fix an Empty Access Query Import in Excel
Product
Microsoft Excel and Microsoft Access
Device & OS
not provided
Scenario
Tables import successfully, but the user also needs to import filtered results from saved Access queries.
Observed behavior
The saved query may appear in Excel's Navigator but return no rows when criteria are applied; removing the criteria returns all records.
Before you start

Open the Access database and identify the saved query and the criteria it uses. Check whether the query depends on a form, a parameter prompt, or a custom function that may not be available to Excel.

Solution 1Recommended

Check and correct the Access query criteria

Use this approach when a query returns records without criteria but appears empty when imported into Excel.

1
Test the saved query

In Access, open the saved query from the Navigation Pane and check whether it returns the expected records. Note any prompts for parameter values.

2
Inspect criteria and parameters

Right-click the query and select Design View. Review the Criteria row for misspelled field names, references to open forms, and expressions that depend on Access-specific context. Open Design > Parameters to check any declared parameters.

3
Isolate the condition

In Design View, temporarily remove or simplify one criterion at a time, then select Run. Use a valid literal value to test whether the condition itself returns the expected rows.

4
Save and import again

Correct the criteria or replace external references with suitable values, then save the query. In Excel, select Data > Get Data > From Database > From Microsoft Access Database, choose the database and query in Navigator, and select Load.

Check and correct the Access query criteria
Check the work environment: If the same query works on another computer, compare the query definition and the values or forms it relies on. Also check for differences in Access and Excel versions or database connection components.
Free Microsoft Office alternative

Open exported Access results in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open an Excel workbook exported from Access to review and work with the results without changing the original database.

Review and filter exported Access query results in a spreadsheet.Open and edit Microsoft Excel XLSX files for easier migration.Use a familiar interface for everyday spreadsheet tasks.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Access query appear in Excel but return no rows?

Excel can list a saved query even when its criteria depend on a parameter, form, or expression that cannot be evaluated through the connection. Open the query in Access Design View and inspect its criteria and parameters.

How can I find an unexpected parameter in an Access query?

Open the query in Design View and check the Criteria row for misspelled field names or references. Select Design > Parameters to review explicitly declared parameters.

Why does removing the criteria return all records?

Removing the criteria removes the filter, so the query can return every record that meets any remaining conditions. Test each criterion separately in Access to find which one prevents the intended rows from appearing.

Can I get the filtered results into Excel without importing the saved query?

Yes. Run the query in Access, confirm the results, and select External Data > Excel to export them to a workbook. The exported data is a snapshot and must be exported again when it changes.