Importing Access Query

[Guest]

Is there vba code that I can use that will allow me to import queries from
access into a spreadsheet in excel?

What I currently do is create a command button and assign it a macro which
opens the appropriate query, but it does not let me choose from all my
queries. Does anyone know why excel does not let you import all your queries?
And if you do know why is there some way around it, maybe changing the query
to meet the criteria needed to import.

Thanks.

 

[Guest]

Can't you use the Data-->Get external data command for what you're looking to
do?

 

[Guest]

What exactly is that?

Can't you use the Data-->Get external data command for what you're looking to
do?

 

[Guest]

I simply do an edit to select all records of the query result and copy and
paste them into a blank excel spreadsheet. /Sandy