Fix an Empty Access Query Import in Excel
Question details
A user needs to import the results of a saved Access query into Excel when the query contains criteria.

- 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.
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.
Check and correct the Access query criteria
Use this approach when a query returns records without criteria but appears empty when imported into Excel.
In Access, open the saved query from the Navigation Pane and check whether it returns the expected records. Note any prompts for parameter values.
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.
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.
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.

Export filtered query results directly from Access
Use this workaround when Excel cannot evaluate the query's criteria or parameters.
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.

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.




