Getting query data from Access

  • Thread starter Thread starter Bud Cookson
  • Start date Start date
B

Bud Cookson

I am attempting to pull external data from Access 2007 into Excel 2007. I am
using the normal "Get External Data" > "From Access". I select the
appropriate Access database and go through the configuration to the point of
selecting the query/table. My question is why do I NOT see all of the
queries? I am only seeing some of them. The one that I want is not visible.
I only want to view the data in Excel. Any thoughts would be appreciated.
BUD
 
I figured it out myself. It appears that if the query has parameters, then
it is excluded from the list. Would have thought that it would have done the
request for the parameters but so be it. Hope this helps someone else. BUD
 
Back
Top