exporting to excel

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....
 
J

John W. Vinson

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.
 
J

Jeff Boyce

"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/
 
L

ladydipitbullace

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 [email protected]> a écrit dans le
message de groupe de discussion :
[email protected]...
 
Top