Link to home
Start Free TrialLog in
Avatar of lallentx
lallentxFlag for United States of America

asked on

export multiple queries to 1 excel spreadsheet

I have 5 queries which i need to export into 1 excel spreadsheet. each query will have its own tab in excel.

class anyone?

don't know where to get started. queries are are already built.

all help is appreciated.
ASKER CERTIFIED SOLUTION
Avatar of pique_tech
pique_tech

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pique_tech
pique_tech

(That assumes that you're using MS Access...if not, then I'm pretty sure my method won't work.)
Form what I can understand Execl can read sql staments.  If you are using a sql or access database you can write a stored proceedure to execute multiple queries.  Here is the sytax

create proceedure Myproceedure
as
Select yourColumn
Form YourTable
Where YourConditions
go
Select yourColumn
Form YourTable
Where YourConditions
go

...and so on


Then all you have to do in Execl of any other client side app is run

Exec MyProceedure
go


Note you must be connected to sql or save the stored prceedure as a Macro.

Hope this helps;)
Avatar of lallentx

ASKER

pique tech, I will try your approach first, and Yes! it is MS Access what I'm using.
I'll keep y'all posted.
Pike tech,
you are a genius in my book!

it worked!

thanks so so much.