save query as excel spreadsheet

[djam]

what would be the vb code i can use on a button click to take the results of a query and save it as a excel spreadsheet in the c drive?

thanks

" ahhh computers, how they made our lives much simpler "

 

[PHV]

Take a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[FancyPrairie]

This will also work:

DoCmd.OutputTo acOutputQuery, "YourQueryName", acFormatXLS, "c:\YourExcelName.xls", True