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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Creating a Chart on form from selected data in query. 0
Creating a Search using a combo box and then creating a report. 4
Adding data to MS Access from csv file 0
Access Query to import from Sharepoint 0
importing/linking data from an Access 2003 Query to an Excel 2003 2
Embed the same Excel multiple times 0
Import Data from Access query 8

Top