Excel 2007 Connectivity to Access 2007 Query

  • Thread starter Thread starter Beamer
  • Start date Start date
B

Beamer

When I connect to my Access 2007 database through Excel 2007 and
select an existing query from the list of tables, only 3 rows of data
show up in Excel instead of the full query. However, when I query
Access from Excel using Microsoft Query all of the information shows
up. I am trying to create a table in Excel that is linked to my Access
query so that when the Excel document is opened it will automatically
refresh. I would appreciate any help on this issue. Thank you.
 
It sounds like you should look at the Access Query, the result suggests that
there is a condition in it which you are not adding when you use MS Query.

As for having the query refresh when you open Excel, the command is Data,
Connections, Properties, and on the Usage tab check Refresh data when opening
the file.
 
Back
Top