exporting to excel

  • Thread starter Thread starter DJ Finnegan
  • Start date Start date
D

DJ Finnegan

I have over a dozen queries built however, for my reporting I need to export
them all to one excel workbook with different worksheets for each. Is there
a simple way to do this? I am not VB user so please keep that in mind.

Thanks....
 
On Mon, 25 Feb 2008 17:03:00 -0800, DJ Finnegan <DJ
I have over a dozen queries built however, for my reporting I need to export
them all to one excel workbook with different worksheets for each. Is there
a simple way to do this? I am not VB user so please keep that in mind.

Thanks....
Click to expand...

You can save the queries as queries, and then use File... Export to export the
queries to Excel.
 
"over a dozen", "export ... all to one excel workbook", "simple", "not VB
user"

It sounds like you are looking for a "magic button" solution to a less-than
simple situation. I'm not aware of a button that can do that yet, but
Microsoft is continually automating features in Access so maybe someday...

Have you considered hiring someone who has more experience?

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
helllo i wood like to geat mi adresse owt of youre seding list ple i ve got
over 300 mail end dont no how to geat rd of dem than u ladypitbullace :O)

"DJ Finnegan" <DJ (e-mail address removed)> a écrit dans le
message de groupe de discussion :
(e-mail address removed)...
 
Back
Top