Exporting to Excel gives me only header row

[HilaDG]

Hello All,

I have a query database written in Access that lists some queries.
In order to view those queries my users use Excel. They go to data->Import External Data -> Import Data -...> choose the .mdb -> choose the query.
Usually it works just fine, BUT
My problem is that with one of the queries it give me only the header row.
Does anyone have a clue for why does it happen and how to pass over it?
thank you in advance for your help,

Hila.

 

[Alansidman]

What happens when you run the query in question from inside Access. Do you get the expected results or do you get only the header rows?

Alan

 

[Bilbo_Baggins_Esq]

If there are results on other queries, but not on this one, I'd tend to think there may be no actual query results to display.

Have you manually run the query in access to confirm ther are valid results to display?

Do any of the fields in this query rely on form objects as a criteria?

Can you post the SQL for the suspect query?

 

[HilaDG]

Thanks a lot for the replies from above,
Yes, this query does give results running from Access
But I just happened to solve this.

And I think I found a bug (!) in this product
The problem lies in a where clause that contains text.
Because of the
"WHERE se_symbol LIKE 'TD*' "
The query doesn't work!
Apparently, there is no problem with exporting queries that contains where clause with numeric values.

My solution was:
Thankfully we are on SQL as back-end, so I extracted all the necessary data with a SQL view, linked it to the queries database and - voila - it worked.

Thanks again for your much appreciated help.