Exporting query/report to pre-defined excel sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Miree - 30 Jul 2007 09:26 GMT

I have a data base containg my results,I need to run a query/report i need to
export the results into an excel speadsheet which already has the defined
fields.
Is this possible? If so how? I am quite new to access, but learning quickly
any advice/help would be greatly appreciated.

Reply to this Message

pietlinden@hotmail.com - 30 Jul 2007 23:49 GMT

> I have a data base containg my results,I need to run a query/report i need to
> export the results into an excel speadsheet which already has the defined
> fields.
> Is this possible? If so how? I am quite new to access, but learning quickly
> any advice/help would be greatly appreciated.

like this...http://www.mvps.org/access/modules/mdl0035.htm

Reply to this Message

balu - 29 Sep 2007 07:58 GMT

dear friend,
i m looking for the solution to xport many querys to an worksheet viz,
(1) on cmd click
(a) create an worksheet
( b) cells(1,1).value = query1
(c) cells(1,2).value = query2
(d) cells(1,3).value = query3
(e)cells(1,4).value = cells(1,1) + cells(1,2)
how to ? kindly advise

> > I have a data base containg my results,I need to run a query/report i need to
> > export the results into an excel speadsheet which already has the defined
[quoted text clipped - 3 lines]
>
> like this...http://www.mvps.org/access/modules/mdl0035.htm

Reply to this Message