export automatically to excel

[GirlBlonde]

Hi i would like to put on a button an automation for exporting a queries data into a specific excel spreadsheet. i only know the code for importing below

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"h:\pcs.mdb", acTable, "Table1", "test", False

many thanks



Energy & persistance conquer all things!

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886