lallentx
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.
class anyone?
don't know where to get started. queries are are already built.
all help is appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(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;)
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;)
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.
I'll keep y'all posted.
ASKER
Pike tech,
you are a genius in my book!
it worked!
thanks so so much.
you are a genius in my book!
it worked!
thanks so so much.