need to send to querie to excel

[cslr]

ok i have tried a couple of things . First i know how to export a table or report to excel using macros but i really need to be able to do this with a querie. i don't se any way to do this i do not know how to prgram VBA so i am stuck their . thanks for any help any one can give me .

[Stingaway]

Other than right clicking on the query and saying 'export' and choosing excel, you have to fire the transfer spreadsheet commands either through a macro or vba code as far as I know. Unless there is some 'on open' property of the query itself that lets you fire the transfer spreadsheet command at that time...

[cslr]

yes i see that i can use the right click or go into file and select export . what i need to be able to do and this is were i am very stuck is automate it . use a click of a button to send it excel . the people who will be using this needs it to be very easy .
thanks for your input.

[Stingaway]

Ok - so create a form that has a button on it. Use the button to fire the macro that exports the data...

[cslr]

that is the part i am stuck on building the macro to do that . i have looked and looked and can not seem to figure that out . i have a macro that can send a table but can not figure out how to send a form data or querie

[Stingaway]

Create the macro, might have to "show all actions" (can't remember..), use the ImportExportSpreadsheet (2010) option, set it to Export, give it the table or query name, give it the file name, choose whether or not you want it to have field names, and provide the range (leave it blank for all).

Save it, then call it from the form.

[cslr]

yes the problem is this is on office 2003 i see on the newer version it is easy to do .

[Stingaway]

You can do the same thing in VBA behind the button - I believe in the macro its the transferspreadsheet command (2003).

For a vba example look at http://www.access-programmers.co.uk/...d.php?t=188472