Importing Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
I simply do an edit to select all records of the query result and copy and
paste them into a blank excel spreadsheet. /Sandy
 
Back
Top