how to automatically output the same query multiple times to excel
am 04.01.2008 13:45:10 von mike_boghossianGood morning,
I am a relatively novice access user. I was given the grand
assignement yesterday of outputting queries for a sales organization
to excel and repeating this once a week. The queries are simple, but
I need to have a separate query for each salesperson (approx 300).
Plus, I then need to arrange each-salesperson's queries into a single
excel workbook (one query per worksheet).
The data is too large to do it completely in excel. I have used
access quite a bit but I have never had to do something like this.
Any ideas?
Cheers!