pro needed to help export Queries

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

Guest

I have a Database which to save time training management levels how to use i
have created an excel analysis pack which is sent to everyone, i have 3
queries which i just open manually and copy and paste into the excel file
named "review.xls".
The Queries are called "rev1", "rev2","rev3", each query goes to the
required worksheet i.e rev1 goes to worksheet "rev1 import" what i want is
for the ability in access to create a macro to open and paste these records
automatically without me having to do this copy paste process everyday. i
have tried the excel data import but the nz function is utilised in these
queries and Excel does not find the queries.

can someone please help me by pointing me in the right diretion in terms of
the code required, i haver looked up transfer spreadsheet function but it
does not seem to work either

can anyone help

thanks in advance
 
With the query open in datasheet view, click "Tools", "Office Links",
"Analyze it with MS Excel". The resulting spreadsheet will have the name of
your query.
 
Another way: There is a macro choice in the Access macro design view that is
"TransferSpreadsheet." While the arguments call for a table name, you can
also type in the name of a query (and the name of the spreadsheet to be
created).
 
Back
Top