Query Results not pulling through into Excel or Tableau

[accessmatt]

Hello,

This is really strange but I created a query in Access which works fine, showing my data as desired. However when i try to import that query into Microsoft Excel or Tableau, which I do often, all of the records are blank. Doesn't make any sense to me, anyone have any ideas?

Thanks,

[ssanfu]

Not enough info to give a good answer.

How are you importing the data from Access to Excel?
- Copying the data from the query and pasting into Excel?
- Using automation?
- Using code?

Details please........

[accessmatt]

Steve,

I'm using Data > From Access process to import. This usually works fine and I use it often.

[ssanfu]

I've imported the data from 5 queries in 5 different dBs and didn't have any problems.
I would have to say that there is possibly a problem with the query in Access. Does it have any parameters in the query?

[accessmatt]

hi Steve, no parameters on this one. Just criteria to filter a text field.

[ssanfu]

Are the parameters hard coded in the query or are you referring to a control on a form?

[accessmatt]

hard coded and here's the SQL

SELECT [Data Feed].Month, [Data Feed].[Exit Links], [Data Feed].VisitsFROM {Data Feed]
GROUP BY [Data Feed].Month, [Data Feed].[Exit Links], [Data Feed].Visits
HAVING ((([Data Feed].[Exit Links]) Like "*Plan_Detail*"));

[ssanfu]

"Month" is a reserved word and shouldn't be used for object names. Plus it is not descriptive.... "Month" of what???
Shouldn't use spaces in object names.

Does the data really have an underscore in the data? ......-> Like "*Plan_Detail*"

There is a opening brace instead of an opening bracket in the FROM clause.....-> FROM {Data Feed]

SELECT [Data Feed].Month, [Data Feed].[Exit Links], [Data Feed].Visits 
FROM {Data Feed]
GROUP BY [Data Feed].Month, [Data Feed].[Exit Links], [Data Feed].Visits
HAVING ((([Data Feed].[Exit Links]) Like "*Plan_Detail*"));

[accessmatt]

Steve, it seems to have something to do with the Like expression. When I remove that it works fine. Problem is I need to use it! Any thoughts?

[ssanfu]

Hmmmmmm....

Could try changing the query to use WHERE instead of HAVING.

Create a new query, change to SQL view and paste in the following SQL

SELECT [Data Feed].Month, [Data Feed].[Exit Links], [Data Feed].Visits 
FROM [Data Feed]
WHERE [Data Feed].[Exit Links] Like "*Plan_Detail*"
GROUP BY [Data Feed].Month, [Data Feed].[Exit Links], [Data Feed].Visits;

Change to Design view to see what it looks like in the query designer, save the query and execute it. It should return the same results as the original query.
Then try an import from Excel using the new query.

[accessmatt]

Steve, thanks but that still didn't work for the Excel import.

[accessmatt]

Steve, I just used Access's Make Table feature on that query to make an actual table and that worked for Excel. Not sure why as I'm usually able to import queries directly into Excel but glad I found a solution.