Getting query data from Access

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
 
B

Bud Cookson

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
 
Top