Share via

Excel Import from Access is empty

Anonymous
2018-04-26T15:45:02+00:00

I have and use several queries in an Access 2016 database.  I can run the query and it populates correctly.  I can also export the query to Excel 2016.

The issue I have is with a new query - when importing the data from Access to Excel, the result is an empty set of data with column headers.  The matching query (run in Access) executes property and shows 9023 lines.  

The navigator shows all 48 tables and queries in the database.  Other queries preview fine.

Any ideas?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-26T16:45:10+00:00

    Duane, thanks for the reply.  I found the issue with more searching.  It was the issue of Excel not recognizing the "*" wildcard in the Access criteria.  I had to change the setting in Access to make it use SQL (ANSI 92) standard.

    For those "non-SQL" folks, perhaps MS could put an option in Excel such as "Work with Native Access Wildcards".

    Richard

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2018-04-26T16:48:04+00:00

    Richard,

    Good to hear you got this sorted out and came back with the answer.

    Was this answer helpful?

    0 comments
  3. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2018-04-26T16:18:04+00:00

    Hi Richard,

    Can you provide the SQL view of a query that doesn't work? Are there any parameter prompts or filters on the query?

    Was this answer helpful?

    0 comments