Get External Access data

  • Thread starter Thread starter BBran
  • Start date Start date
B

BBran

Hello,

I am using Office 2007 on XP SP2. I am trying to get external Access data
from a database. When I do a window comes up with Access Tables and Queries
(referred to in the window as View) in it. However, not all the queries are
listed. What determines whether a query is listed or not? There is one I
need that is not listed.

Bob
 
Not sure about 2007, but prior versions worked like this:
Generally, queries are of 2 types: "Action" queries and Select queries

Action queries are those that change data: Update, Append, Delete,
MakeTable, etc. These do not "return" data, per se, just do something to the
data.
Select queries simply filter & present existing data. They provide
"views" of the data. Select, Union and Crosstab queries would fall under
this heading.

Since only Select queries return data, they would be the only "external
data" candidates.

In addition, if a query utilizes a user-defined function (i.e., a custom
function within an Access code module), it won't be listed since the
function would require Access to be open in order for the query to run
properly, and the specific wizard isn't prepared to handle that. (However,
it could still be imported into Excel via automation using code.) I seem to
recall that the use of NZ() within a query would also make it fail this test
since NZ is an Access function (and I think the only Access function). DAO,
ADO and VB functions would all be permissable, iirc.

HTH,
 
Addition:
Any Select query that relies on the value of a Control on an open
Form would also fail the "available external data" test (again, Access, and
the Form, would have to be open for the query to work).

HTH,
 
By testing I found that to be so. If a query required input, it was not
listed. Thanks! :-)
 
Back
Top