Transfer records to Excel worksheet

  • 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 anyone help

thanks in advance
 
rivers said:
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 anyone help

thanks in advance
Click to expand...
 
Back
Top