We help IT Professionals succeed at work.
Get Started

How do I export multiple Access queries into different worksheets on one Excel file

Last Modified: 2013-11-27
I have several queries in an Access 2007 database that I would like to export into one Excel file with multiple worksheets.  (e.g. Queries pull tables for OH, MI, and IN, I would like one Excel file called "District.xls" with three worksheets for OH, MI, and IN.)  I would also like to keep the formatting intact when the files export (so the headers look pretty, bold, grey background, etc.)

My import and data scrubbing module is in the Access file, so I would prefer to stay in Access if possible.  Otherwise, if I need to move to Excel to do this, I am not too terribly attached to doing it in Access.

I am very comfortable with VBA, but my google searches have not produced a "silver bullet" per se.  It's mostly sharing worksheets, linking tables, and the like.  So, 350 points to the person who can get me what I need, please.
Watch Question
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE