Data Import & Export

Fix Excel Access Query Returning Field Names but No Data

Emma Brown Sep 30, 2026 868 views

Question details

The user needs to fix an issue where importing data from a Microsoft Access query into Excel results in blank rows, displaying only the column headers.

How to Fix Excel Access Query Returning Field Names but No Data

Product: Microsoft Excel and Access
Device & OS: not provided
Scenario: Importing or refreshing a data connection from a Microsoft Access database query into an Excel spreadsheet for data analysis.
Observed behavior: The data connection refreshes without any error messages, and the field names (headers) appear in Excel, but the actual data rows remain entirely blank, even though the query runs perfectly inside Access.

Before you start

Before altering your connections, open Microsoft Access directly, run the specific query you are trying to import, and verify that it currently returns records and does not require manual parameter inputs.

Solution 1Recommended

Test Direct Access Table Import and Recreate the Connection

Isolate the root cause by testing a direct table import to ensure Excel can read the Access database properly, then rebuild the query connection.

Often, the issue lies specifically within how Excel interprets the custom query rather than the database itself. By importing a standard table first, you can confirm whether the OLE DB connection is functioning correctly.

Test importing a standard table

In Excel, navigate to the 'Data' tab on the ribbon, click 'Get Data', select 'From Database', and then choose 'From Microsoft Access Database'. Select a standard table instead of a query and verify if the data imports successfully.

Remove the faulty query connection

If the table imports correctly, the problem is with the query connection. Go to the 'Data' tab, click 'Queries & Connections', find the problematic Access query connection in the side panel, right-click it, and select 'Delete'.

Recreate the Access query connection

Go back to 'Data' > 'Get Data' > 'From Database' > 'From Microsoft Access Database', select the Access database file again, choose the specific query you want to import, and click 'Load'.

Test Direct Access Table Import and Recreate the Connection

Database Permissions: Ensure that the Access database is not opened in 'Exclusive Mode' by another user, as this can sometimes prevent Excel from fetching the query data.

Solution 2

Review Query Calculated Fields and Data Types

Complex calculations or unrecognized data types in the Access query can cause the Excel OLE DB provider to fail silently, resulting in blank rows.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Management

If you are experiencing persistent issues with complex Microsoft database integrations or simply need a lightweight, cost-effective solution for everyday spreadsheet tasks, WPS Office is an excellent free alternative. It provides outstanding compatibility with Microsoft Excel formats and offers a smooth, familiar user interface without the heavy subscription costs.

1. Download and Install: Visit the official WPS Office website to download the free installer and complete the setup process.
2. Launch WPS Spreadsheet: Open WPS Spreadsheet, which serves as a lightweight and highly compatible alternative to Microsoft Excel.
3. Open Your Workbooks: Simply drag and drop your existing .xlsx or .csv data files into WPS Spreadsheet to continue analyzing your data seamlessly.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight and fast, preventing spreadsheet freezing during heavy data processing.Familiar ribbon interface ensures zero learning curve for Excel users.Built-in advanced data analysis and visualization tools.

Frequently Asked Questions

Why does my Excel data connection say it refreshed but shows no data?

This usually happens when the source query in Access contains unresolved null values, division-by-zero errors in calculated fields, or incompatible data types that the OLE DB provider cannot process, causing it to return an empty recordset despite a successful connection.

Can I import an Access database into WPS Spreadsheet?

Yes, WPS Spreadsheet supports importing standard data formats. While direct OLE DB queries might vary by system configuration, you can easily export your Access query results as a CSV or Excel file and open them directly in WPS Spreadsheet for analysis.

How do I fix calculation errors in my Access query preventing Excel imports?

In Microsoft Access, use the 'Nz()' function to handle null values in your calculations (e.g., handling empty fields before applying 'Avg' or 'Round'). This prevents the calculation from failing during the export process to Excel.

Excel & Data Problems