Using Microsoft Query with Access via Import External Data?

[Guest]

Pulling data down via MS Query into Excel is pretty easy. I have reached the
point where there's too much data to fit on an Excel sheet though (really
working with Pivots).

Access doesn't seem to have an easy way to hook into the MS Query SQL (.qry)
files to pull data into an Access table though. Would love to see this - or
maybe the feature's there and just works very differently?

-mg


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a9333&dg=microsoft.public.access.externaldata

 

[Guest]

Anything MSQuery can do, Access can do, but I don't think
you can hook into the .qry files.

In Access, open a database, then go to File, Get External Data,
Link Tables. (Or you can 'import' to get a copy of the data.

You can select "Files of Type" Text, Excel, dbase, etc
(depending which IISAMS you have installed) and ODBC,
which gives you everything else.

Then create a new query, to give you mixed source queries,
and more sophisticated queries than MSQ can create.

(david(

Pulling data down via MS Query into Excel is pretty easy. I have reached the
point where there's too much data to fit on an Excel sheet though (really
working with Pivots).

Access doesn't seem to have an easy way to hook into the MS Query SQL (.qry)
files to pull data into an Access table though. Would love to see this - or
maybe the feature's there and just works very differently?

-mg


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a9333&dg=microsoft.public.access.externaldata

 

[Guest]

I also would like an answer regarding the original question.

Due to corporate policies I have read-only access to a DB via ODBC. I want
to perform queries via MS Query and pull the results into MS Access.

I cannot use Excel as a middle-man - the query result is too large.
I cannot Link or Import the data directly from the DB

So is there a neat way I could get data from MS Query to Access?
Programmatically?

 

[Douglas J. Steele]

Why can you not import the data into Access? You shouldn't require anything
more than read-only access for that.

 

[Guest]

They've yet to take away my admin rights or access to the data so that did
the trick. I was able to direct the query to output into a database table
to create a local copy of the data using a drop down menu in the queries
screen to set the query type -- worked like a charm, thanks!

Back to analyzing the 300mb of data I pulled down . . . :-D

-mg

 

[david epsom dot com dot au]

If you can view, see, read, or understand the query
in MS Query, then you can re-create the query in Access.

Access is just a larger, bigger, better copy of MS Query.

(david)