Excel not reading correctly data from Access

Question

Hi all, I am having an issue with an Excel file which contains 6 connections to different queries of an Access file. When I first created the connections, the data was retrieved correctly, i.e. in Excel I could see the field names and the values in the following rows. Now 5 out of 6 connections do not get the correct data: I get the field names in the first row, but the following are empty. In Access the queries are running just fine and reporting the correct results.

No errors are thrown during the refresh process in Excel, at least if I refresh the connections one by one (if I click "Refresh all", I will get errors, but it was always like this, even when the connections were working fine).

I have already tried deleting and re-creating the queries, but nothing changed.

Can you please help me understand where the issue is?

Answer 1

You may try linking that access table directly into Excel.

Data>Get data from Access>Select the table(s) you want to import from the database

Answer 2

here it is:

SELECT Round(Avg(T0),1) AS T0_medio, Round(Avg(T1),1) AS T1_medio, Round(Avg(T2),1) AS T2_medio, Round(Avg(T3),1) AS T3_medio, Round(Avg(T4),1) AS T4_medio, Round(Avg(T5),1) AS T5_medio, Round(Avg(T6),1) AS T6_medio, Round(Avg(T7),1) AS T7_medio

FROM Tabella_tempi_SR;

Answer 3

Could you share your query code?

Answer 4

Hello, here are the screenshots:

Excel not showing any error in the connections, but the table is empty:

While the Access query that the connection points to is OK:

Answer 5

Is there any error message or notice? Could you share a screenshot?